I'm trying to create a tracker that my employees must update. Each employee has their own worksheet. The first worksheet is a splash page where they can click their name and it will automatically jump to the worksheet assigned to them.
There is also an overall worksheet for their leadership...
I would like to have a combo box drop down that would allow a user to select a date from a specified range (which is based on values selected on the "ToolSettings" sheet, specifically the "Select Admissions Term" value) - the combo box is sitting at "Select Test Date" (B10)
AB56Select...
Hi,
I have coded wages report with ID No selection in combo box.
What I expecting is When I typing 1 in combo box, display 1 related numbers and then click tab button related name in textbox.
Here these changes happening in scrolling or mouse clicking options only.
Can experts guide me to...
Hi,
I need experts support.
In userform there are 7 combo boxes and each combo box values from Common from Cell A1:A.
Cell A1:A Values are
Peter
Micheal
Nick
Jump
Mary
Catherine
.....
.....
.....
etc.,
My question is When I selected 1st combo box value = "Peter" and then all other 6 combo...
I am trying to populate a UserForm ComboBox drop down list and it is also picking up the blanks that are in the column. How do I remove the blanks in the ComboBox on the UserForm. I have not found any code that has worked for this issue.
Some data are in a row. They are renamed. Can the renamed range be converted into a combo box list?
For example, names of days namely Sunday, Monday.........Saturday are in a row in place of a column. The range is renamed as 'day'. Can the renamed range be converted into a combo box list? If...
Hello, hope everything is good!
I will try to be the most clear with the goal I'm tryin to achieve:
I have a Sheet1 where I would like to enter a given record with some information about Country; Transit Type; Incoterm; Forwarder; Currency info.
This would be almost what I needed (it...
Hi, I have a userform that needs to output the names of suppliers ("Fornecedores") and banks ("Banco") from a table in the respective combo boxes, FornecedorBox and BancoBox. For that I used the following loop and it has been working perfectly until I migrated the file from my personal computer...
I want to use this combobox menu dependently to access 10 different category menu with its sub-category, item, sub-item etc.
The vab code isn't displaying the menus with ID 10, 100, 101 etc, please how do I fix this? I have been on it for a week now, but no luck.
PLEASE HELP!!!
Option...
Hi,
I created comboboxes with dropdown lists
I presently have formulas that searches through a long list (7000) of names and then once found information is auto-populated in identified cells
This is the search mechanism I presently have in place
In Column K...
Hi
I have created a user form with a number of textboxes . The Textboxes are pre populated based on an excel data base
I would like to add a Combobox with properties of "Yes" or "No" in the drop down list.
The number of rows is dependent on an end user selecting their email address and...
Hi,
I created a UserForm that requires a datepicker to show based on the value of combobox
I tried
Sub End_Date ()
If Me.TxtTenure.value = "Term" Then DTTenure.Show
Else
DTTenure.Hide
End Sub
that didn't work and looked through previous posts and couldn't find...
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...
Hello guys,
I am creating a template to log activities and account history and I am unable to add data if my table would start in a cell not at the beginning of the sheet (ex. first column is at C33).
The template I am creating will be the same template used for each new sheet generated named...
Hi everybody. I'm having issues with setting up multiple drop-down boxes to auto-complete with a set list of data values. I've got two tabs that have multiple drop-down boxes utilizing the same data values from a third tab. Because some of the drop-downs have multiple selections (Country for...
I made a form with 3 different Combo Boxes, "Age, Gender, Coverage"
I want to be able to apply the selected items to a sheet but I only need the value of the table when all three are applied to populate the cell in the sheet.
For example:
I open the form, select "Male, 18, 250K" click button...
Hello,
I want to use autocompletion in a combo-box. I think it's not that hard to accomplish. I already have that code (VBA).
Now I want to do the following:
I have a sheet (ProductSelection) were I have 3 combo-boxes and a lot of other cells which have to be auto-populated when searching for...
Hey Friends,
Hope all are doing well.
I just made one drop down by using combo box.
I want to select items by using up/down arrow keys.
is it possible? please help
Regards
Dear Friends
I have data on sheet1 cells A2:A8900 and want to link them to combobox 2 in userform (VBA) without replicated and blank cell (cells are updating).
How do it?
Thanks
I currently have 2 separate comboboxes pointing to separate named lists.
I added some vba to create an autocomplete dropdown.
The code points to the correct combobox and references the correct list for each combobox.
My problem is that when I type in the first one, select a value from the...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.