userform buttons with frame stopped working

[littlepete]

hello

to get around my list, i created a userform with a lot of buttons.
I grouped them together along what their function is.

since i added the frames (made with a transparent textbox) the buttons are unreachable...

what should i add in vba to be able to click my buttons again?

thank you !!!

ps
those who follow me know i had a big problem with reading the button texts, well
since that is solved i'm now working on my userform !!!

 

[My Aswer Is This]

If you want put your buttons inside a Frame.
You should see Frame in the Toolbox.

Do not put your buttons inside a transparent textbox
You said:
since i added the frames (made with a transparent textbox)

 

[vw412]

I would second My Answer Is This answer about using a Frame rather than a transparent textbox. However, be sure to put the Frame on the UserForm before putting buttons in it. The Frame is touchy about how you bound other objects in it. Also, adding buttons to an existing frame will make it possible to move the group of buttons just by moving the Frame.

Another option to experiment with is putting a Label on you UserForm and size it to fit all the buttons you want on it and then add the buttons on top of it. I haven't tried this specifically but have experimented with layering controls on top of one another to get different effects.

 

[littlepete]

I would second My Answer Is This answer about using a Frame rather than a transparent textbox. However, be sure to put the Frame on the UserForm before putting buttons in it. The Frame is touchy about how you bound other objects in it. Also, adding buttons to an existing frame will make it possible to move the group of buttons just by moving the Frame.

Another option to experiment with is putting a Label on you UserForm and size it to fit all the buttons you want on it and then add the buttons on top of it. I haven't tried this specifically but have experimented with layering controls on top of one another to get different effects.

thank you so much !!! indeed first the frame and then the buttons, there was a lot of moving around involved hahaha !!!
have a great sunday !!!

 

[My Aswer Is This]

thank you so much !!! indeed first the frame and then the buttons, there was a lot of moving around involved hahaha !!!
have a great sunday !!!

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[littlepete]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

hello

next step is to explore the backcolor options with rgb...
but i dont find the right place to write "ufaddresslist.backcolor = rgb(255, 255, 255) (as example)

where should i change the backcolor of some buttons?

thank you

 

[My Aswer Is This]

hello

next step is to explore the backcolor options with rgb...
but i dont find the right place to write "ufaddresslist.backcolor = rgb(255, 255, 255) (as example)

where should i change the backcolor of some buttons?

thank you

Why do you need to use vba to change Background color?

Is the color going to be changed do to something happening?

 

[littlepete]

Why do you need to use vba to change Background color?

Is the color going to be changed do to something happening?

hello

i would like to give all buttons doing similar things give the same background:
for example the exit userform button with a red backcolor; filtering (two buttons) with a green and so on ...

now all is in the same (boring) color so far ...

 

[My Aswer Is This]

Do you know you can click on the control and in the Vba editor properties window choose
Forecolor or Backcolor click the down arrow and choose Palette and select the color you want.

 

[littlepete]

Do you know you can click on the control and in the Vba editor properties window choose
Forecolor or Backcolor click the down arrow and choose Palette and select the color you want.

hello

i was only looking for vba to change it this is a good way too ! thank you again my creative mind can go loose again

thx !!!