Define activex combobox list by Array and def dbclick action in loop for multiple button

I designed a UserForm.

1- I want the value of ComboBox1 defined as an Array 01, 02, ... ,12 and ComboBox2 defined as an Array 1385, ... ,1410?

2- How can I write a For loop that by double-clicking on any button from 1 to 34, the caption of that button along with the value of comb1 and combo2 will be stored in a variable named TARIKH?

I mean

TARIKH = "combo1.value" & "combo2.value" & commandbox(i).caption

You already have Cllick event for CommandButton 2 to 32, so no need to have event procedure by withevents
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by torachan

@niksarat2030, if you refer back to one of your previous posts you will find the inclusion of a calendar form.
By a small adjustment (two numbers) and referring to the combobox lists you would have a far cleaner and less code overhead app.
Please, please stop using 'RowSource'

For reasons that are a bit complicated, I had to implement an idea in Excel using VBA and this is my first encounter with this programming language!!

The manager of the company where I work has asked me to write a program (not very fast, of course) that gives the company's data (from contractors' information to production levels, etc.) by different users (storekeeper, manager, accounting officer, etc.) and finally prepare reports according to those data, including employee performance charts, efficiency levels, etc (In this post, I asked for help to add a bar graph to this form, but no one has helped me so far).

Because the company's data is stored in many Excel sheets, at first I saw the only way to use VBA. And I don't know what is the best way. Of course, in 001 and 002 posts, I asked for some guidance. If you, as someone who has much more experience than me, can guide me.