I got an issue which my VBA script in excel that i need some expert help here.
The situation is i have 20 combo box added in the excel worksheet which i group as the same category such cboxName1, cboxName2,...cboxName20 because i could not make an array control box. Then I want to write a small routine which i can use loop function to read all the value in these control using a variable to identify the specify combo box ? For example whati like to do is as below but that does not work :
For i = 1 to maxcnt
var & i = worksheets(1).comboName & i ".value"
please help me with my problem Thank you.