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
This code should do what you want.
If CheckBox1.Value Then
drawer = Application.WorksheetFunction.VLookup(ComboBox4.Value, Worksheets("data").Range("A1:B10"), 2, 0)
End If
- Change checkbox1 to the name of your checkbox control.
- Change combobox4 to the name of your combox control.
- Change data to the name of your worksheet.
If CheckBox1.Value Then
drawer = Application.WorksheetFunction.VLookup(ComboBox4.Value, Worksheets("data").Range("A1:B10"), 2, 0)
End If
- Change checkbox1 to the name of your checkbox control.
- Change combobox4 to the name of your combox control.
- Change data to the name of your worksheet.
Upvote
0
Excel Facts
Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Saagar
Board Regular
- Joined
- Aug 24, 2011
- Messages
- 205
I just used "drawer" as an example. You may assign the result of the formula to some other variable that you already have in the code.
Since the drawer models are strings, you need to use "Dim drawer as String" to declare the variable. The code will still work without the declaration but it is a good practice to declare it.
Since the drawer models are strings, you need to use "Dim drawer as String" to declare the variable. The code will still work without the declaration but it is a good practice to declare it.
Upvote
0
