userform buttons with frame stopped working

littlepete

Well-known Member
Joined
Mar 26, 2015
Messages
503
Office Version
  1. 365
Platform
  1. Windows
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 ;) !!!
 

Attachments

  • 2022-03-05.png
    2022-03-05.png
    39 KB · Views: 15
A Vba solution would look like this:
VBA Code:
UserForm1.TextBox1.BackColor = vbRed
 
Upvote 0

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
A Vba solution would look like this:
VBA Code:
UserForm1.TextBox1.BackColor = vbRed

INDEED !

i did try, but i didn't find where exactly i had to put that ( i tried x.initialise ; x.change ; module ; ...
but using the pallet in the button options is very nice and sufficient :) !
 
Upvote 0
To use Vba you would need this type code put in your userform.
The code runs when you open the userform.
VBA Code:
Private Sub UserForm_Initialize()
TextBox1.BackColor = vbBlue
 
Upvote 0
To use Vba you would need this type code put in your userform.
The code runs when you open the userform.
VBA Code:
Private Sub UserForm_Initialize()
TextBox1.BackColor = vbBlue
i tried :

Private Sub ufadressenlijst_initialize()
TextBox4.BackColor = RGB(160, 80, 0)
end sub
( uf (userform) + adressenlijst = addresslist... )

but there is no result... my signature (right bottom) should color brown... it stays grey...
i tried ufadressenlijst.textbox4.backcolor but same result...


To use Vba you would need this type code put in your userform.
The code runs when you open the userform.
VBA Code:
Private Sub UserForm_Initialize()
TextBox1.BackColor = vbBlue
 
Upvote 0
If the color is to always be the same, I would set it in the properties window.
But if you plan to change the color due to certain conditions, I would use vba Color
I really do not know what the RGB color is for Gray. I would have to do a search for that.
 
Upvote 0

Forum statistics

Threads
1,215,066
Messages
6,122,947
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top