combo

Hi guys, hope everyone is having a great day, i need help with regards to my multi-tab userform on vba excel. I currently have 6 tabs and each tab there are are about 5 combo boxes, and a NEXT & CANCEL command button. I want a code that if the user forgets to click on one of the combo boxes...

I have the code I like to use to fill combo box by 10's from -100 to 100. (i.e. -100...-30, -20, -10...0...10, 20, 30,...100) Also I like to format numbers as percentage. Thank you Can anyone assist. Thank you kindly. For i = -100 To 100 cbPct1.AddItem i Next i

Hi everyone, Super new to writing VBA code. I'm trying to set up a rudimentary document control numbering system. 2 sheets in the workbook, "Doc List" & "Options". I have applied the offset formula for the items under names, and assigned them to names. These are: Author_Name; Discipline...

I have been working on a project for a while now. I have the file on a flash drive. I tried working on it at my GF's and Excell is CTD for some reason. The project is using combo boxes to make a selection and then put them in a named range. This has been working fine right up to now. This...

I have the code below in a userform, with 5 combo boxes. I need Combo Box 2 to display a time, but I can't get it to work. I've had a look around and tried a few suggestions, but can't seem to get it. Any suggestions would be hugely appreciated. ' Open UserForm1 when the workbook is opened...

i have read through multiple forums and cant find a solution that has worked so far. the check box will be unchecked when the form opens. the options are Yes (with checkbox) or No (with checkbox) as of right now, if the checkbox for Yes is selected, multiple items will appear to prompt the...

Hello, ComboBox ListFillRange is base on month text, If I select the month of January from combo I want that month number will linked to call AP2 as month. Is there any code for combobox change function? Thanks

I have a Combo Box on a User Form with a dynamic items list (gathers the item list from a spreadsheet based on active cell value when the user form activates). How can I make it so that the user must choose one of the options from the Combo Box (no manual typed entry)? IF manual typed entry...

hello friends I know how to display one column in combo box using data validation but I would like to know is it possible to display two columns in combo box? What I am trying to do is automatically fill adjacent cell with corresponding data when I select an item in combo box. thanks

Hi, I have an userform with a combo box and a textbox and I am trying to get the textbox to show the corresponding value of the chosen item in the combo box. The combobox is named ComboBox1 and the textbox is named Textbox1. When I select item1 I want the textbox to show the text for item1...

Once the combo box has been clicked and the value saved to a variable is there a way to get the range that was used? In my case the "row". I have a list (range) of customer names and phone numbers and such. After selecting a customer name from the combo box I want to fill out a sheet with all...

Hello All! Thanks for reading first off What i want to beable to do is have two combo boxes on a form which when i select a Zone then the second combo box only shows details assoicated with that Zone. I have looked at this video on you tube https://www.youtube.com/watch?v=pMiJHhjzC8Y With...

Hey everybody, I'm new to this forum, so I apologize if this isn't where I should post this question. I'm currently taking an intro to excel class at school, and am stuck on an assignment. I really have no idea what I'm doing wrong, because as far as I can tell, I followed the instructions...

Hello All, I need a little help. I am using four combo boxes from the data ribbon Controls-Insert-Forma Controls Combo box (Form Control). All four have a cell link that provides a number based on each selection. So when Select a value on my 1st box, the 2nd combo it is populated based on...

'declare variables Dim combo As String 'Combo worksheet name Dim SortTable As String 'Table name that needs sorting 'assign values to variables combo =...

I am trying to sort a table by the date column with this code: 'declare variables Dim combo As String 'Combo worksheet name 'assign values to variables combo = Worksheets("Home").Range("Q5")...

I've just moved from a Windows PC to Apple MacBook Pro. Love the Mac once I got myself familiarised with the new operating system etc.... Problem I have is with old Excel Flies I've previously created which use Combo Box for Dropdown menus created within Developer. The Developer Ribbon...

Heeeeey guys :) I'm hoping this is a quick simple one:) I have a user form with a combo box that allows the user to select a team name. The next combo box I want to populate with tasks based on the team selected in combo box 1. I also need to apply this same code to 5 more combo boxes. (The...

I want to add items to a combo box however I want to restrict the range to A3:A12. Also, I notice in the current code, when I click the drop down arrow, it displays the empty ranges. Is there a way to not show these ranges if the cells are empty? Can someone assist with this task. Thank you...

Please help as I am still learning vba and I don't know how to debug code yet. This is the code I have written: Sub cmdCopy_Click() Application.ScreenUpdating = False 'Modified 10/25/2018 10:15:34 PM EDT Dim Lastrow As Long Dim Combo As String Combo = Worksheets("Home").Range("Q5")...