[SOLVED] VBA Changing button.caption with the same Button.Name

**mcmunoz** · 09-26-2013, 09:31 PM

I have a problem with my code. There is an error written as BOLD characters in the code section.

I have a sheet that I want to change all of my button.caption named btn1, btn2, btn3, btn4, btn5...... so on and so for at least 49 buttons.

Please Login or Register  to view this content.

P.S: Developer Tab -> Form Control -> Button

**Andy Pope** · 09-27-2013, 03:39 AM

Please Login or Register  to view this content.

**mcmunoz** · 09-27-2013, 04:49 AM

Originally Posted by Andy Pope

Please Login or Register  to view this content.

Nice code!

Thanks for helping me Andy. Its working, I can now proceed to my work.

Can I have a favor, can you give me a link all about information/syntax of a form button.

**Andy Pope** · 09-27-2013, 04:58 AM

As the code defines the object as a shape you should get intellisense.

You could try using the object browser (F2) in VBE

[SOLVED] VBA Changing button.caption with the same Button.Name

LinkBack

Thread Tools

Rate This Thread

Display

[SOLVED] VBA Changing button.caption with the same Button.Name

Re: VBA Changing button.caption with the same Button.Name

Re: VBA Changing button.caption with the same Button.Name

Re: [SOLVED] VBA Changing button.caption with the same Button.Name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Changing the Caption of an Option button in a userform using vba

[SOLVED] Is it possible to do a comm.button with scrolling caption /changing caption?

Changing Command Button Caption with userform Open

Changing the caption of a Command Button

[SOLVED] changing the caption of a command button

Bookmarks

Bookmarks

Posting Permissions