Answer:
By using the below command we can able get the ComboBox value from other sheet or module.
Dim abc
abc = Sheet1.ComboBox1.SelText
By using the below command we can able get the ComboBox value from other sheet or module.
Dim abc
abc = Sheet1.ComboBox1.SelText