Defining a variable to select a button on a form

[markusjbear]

I have a form with several buttons. The button names have a common part distinguished by a number in the name. I what to write a loop that selects button1 and changes the caption of the button and proceeds through button(n). Can anyone help me define a variable that can be used within a loop that can be used as the name of the button to change the features of the button ?

[Leith Ross]

Hello markusjbear,

Welcome to the Forum!

You should post a copy of your workbook. This will provide all the information needed to develop and test any solutions.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture

[markusjbear]

Calander, 130228.xlsm

Thanks for your help. I hope I added the file correctly.

Basically, I am recreating the calendar function and I have 42 buttons (7 X 6). I would like to access them in a loop to set the caption of the day value. Can i make a variable that references the button and make a loop as follows?

Please Login or Register  to view this content.

thanks

[nilem]

Hi markusjbear,
try this

Please Login or Register  to view this content.

[markusjbear]

Thank you very much. This did the trick.