Hi Friends ,
I am trying to put the value selected in combobox in a variable but its showing Run Time error 424 - Object Required .
Here is my code :
I tried using
But it also doesn't work .
NOTE : DD_Sell is the name I have for combobox in Formula bar of excel. In my excel file , this combobox is having list of the names of different sheets in my excel file.
Please help.
I am trying to put the value selected in combobox in a variable but its showing Run Time error 424 - Object Required .
Here is my code :
HTML:
Dim dd_val As String
Dim Data_sht As Worksheet
dd_val = DD_Sell.Value
Set Data_sht = ThisWorkbook.Worksheets(dd_val)
I tried using
HTML:
dd_val = .List(.value)
But it also doesn't work .
NOTE : DD_Sell is the name I have for combobox in Formula bar of excel. In my excel file , this combobox is having list of the names of different sheets in my excel file.
Please help.
Last edited: