userform code

Hi I am building a userform that will add 3 fields to the next row in a worksheet. The worksheet has 3 columns with 2 command buttons in the 4th column labeled Add DAA and Edit DAA. Like below <tbody> DAA Career Path Skills/Strengths Add DAA Edit DAA </tbody> The UserForm has...

Hi, Hoping someone could advise me here. I have an execl spreadsheet preloaded with data on multiple sheets. I am currently using multiple userForms to display the data. On userForm1 i have two listboxes. I move values from listbox 1 to listbox 2 using a button called 'Select_cmd'. Prior to the...

I am working in Excel 2013. I am trying to create an UserForm for my department for formatting reports that we create that don't come out "Pretty" I have a few text boxes for things like freezing the sheet on XX, print titles, naming sheets, etc etc At the bottom of the user form, I have a...

I'm new to vba so please forgive my ignorance. I am using Excel 2010 on Windows 7. I have created a custom userform in a workbook "Assistant Hire Log - Individual". The userform works correctly in populating sheet 1 "Hire Log". Upon pushing the "OK" button, I would like the userform to also...

hi everyone, I'm creating a workbook, for all the manger in my company. they have to have access to their department's sheet + the summary sheet. So here is how I did. when closed the workbook automatically set the visibility of every sheet to xlVeryHidden. when open a user form is shown...

Hi Guys I'm familiar with creating UserForms using Excel VBA, but is it possible to have several command buttons access the same UserForm layout with variables for row and column dependant on the command button pressed? I have a worksheet that contains all the information on several stores. My...

Hi there, I am trying to make a program which filters out selections based on inputs and in the end, will come back with a list of possibilities (specifically it is for motors so they enter in whatever they would like, RPM or Frame etc.., and then it gets a price). I have 4 comboboxes that are...

Hi There. Is there a way to control what happens when a button is clicked under the userform_initialize event? I am not sure I understand the hierarchy of how to properly create a Userform. I have public variables declared in a module and need to use those values in the dropdown box menu, but I...

Hi I have Created a excel user form with three Combo box and list box with 3 columns. When user selects a value from drop down list and click Add button it will be displayed in the list box - Done When user selects a item in the list box it will again displays in drop down list - done But when...

Hello I am looking for a way to populate column B onwards when "number" in the userform matches with column A. I can populate data in the next blank row but want to put say number 92 in and then have all columns for number 92 populate with the info I have put into the userform. Private Sub...

Hi all, I am new to VBA, using Excel 2010. I am working on spreadsheet that I need to process every month, dealing with upwards of 2000 rows of data in 45 columns. Column A lists employee names; column S lists their current job titles. I have a For... loop that examines each job title and...