Does anyone know of a way to allow a cell on my sheet be updated by a vlookup property when a checkbox is clicked? I have 4 comboboxes and when the last combox is selected I need that part number to be looked up by the checkbox if its selected and have that value put into another cell.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
checkbox vlookup
- Thread starter sappster
- Start date
Saagar
Board Regular
- Joined
- Aug 24, 2011
- Messages
- 205
I hope you are using a "Forms" CheckBox. If so, right click on the check box, select "Format Control" option. In the "Control" tab, in the Cell Link field, put a cell in the sheet. When the checkbox is checked or unchecked, the value in the cell will change between "true" or "false".
You may then put this formula in another cell.
IF([linked cell],[vlookup function],"")
If the checkbox is checked, the cell with the above formula will show the vlookup value, otherwise it will return blank.
Hope this helps...
You may then put this formula in another cell.
IF([linked cell],[vlookup function],"")
If the checkbox is checked, the cell with the above formula will show the vlookup value, otherwise it will return blank.
Hope this helps...
Upvote
0
Saagar
Board Regular
- Joined
- Aug 24, 2011
- Messages
- 205
Just realized that my last post was missing key part of the code as I did not tag the code.
Open the user form in design mode. Right click on the control and select "View Code". There might be existing code. Add this code:
Open the user form in design mode. Right click on the control and select "View Code". There might be existing code. Add this code:
Rich (BB code):
Cells(5, 5) =[name of control]<name of="" control=""></name>.Value
Last edited:
Upvote
0
Saagar, what I need is when the part on the last combobox is selected I want to then click on a checkbox to make it true. And if it is true then I want a VLOOKUP to locate that item in the last combobox and fill the value into a cell on the sheet. If my combobox reads "cabinet" I want the checkbox to go find the corresponding "option" and put the "option" in a separate cell from the cabinet. Can this be done?
Upvote
0
If my combobox has 4 choices: cab1, cab2, cab3, cab4. If you select cab2 and also check the checkbox for drawer options then I want to put draw2 into a cell next to the cab2 cell. if you select cab3, I and select the checkbox then I want draw3 to be put into a cell next to the cab3 cell in the sheet.
Upvote
0
I have a table with 2 columns. One has cabinets as header with all cabinet values, the column next to that has all the draw items which correspond to the cabinets. When the combobox has the correct cabinet AND the checkbox is selected I want the checkbox to use the VLOOKUP to find the cell next to the cabinet in the sheet and add this to my form.
Upvote
0
