Set Variable as ComboBox.Value

[MarkRCC]

Is it possible to set a variable as the value of a combobox?

Specifically, I would just to like to do something like this:

Set X = Me.ComboBox1.Value
Set ws = ThisWorkbook.Sheets(X)

Where X is the value of a combobox selection made previously on the same userform.

Of course, this doesn't work, so any tips would be greatly appreciated!

 

[RoryA]

You only use Set with Object variables, whereas X here is a string data type, so it would just be:

X = Me.ComboBox1.Value

 

[Zubair Muhammad]

Dont use the word Set in first line

Set is only used with objects

X = Me.ComboBox1.Value
Set ws = ThisWorkbook.Sheets(X)