Controls and VBA help

wilkisa

Well-known Member
Joined
Apr 7, 2002
Messages
657
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Good morning, Excel world!

I have two options buttons and one text box. I want the text box to be hidden until Button2 is selected. I then want it to become visible and enabled for input.

Also, I want a message box to appear when 8 specific cells have been filled in.

Does anyone have any code that will guide me?

Thanks,
Shirlene
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Yeah sure, firstly you need to go to the textbox's properties bar and go to Visible, and change it from True to False.

The code you want to put into the optionbutton's change event is:

if optionbutton2.value = true then
textbox1.visible=true
else
textbox1.visible=false
end if

Hope this helps

Audiojoe
Ebony and Ivory, live together in perfect harmony
This message was edited by Audiojoe on 2002-04-18 05:26
 
Upvote 0
AudioJoe, thanks for your help on the first topic. I was coding the optionbutton2 on click, not change. Now it works fine.

How about the message box problem. Any ideas? Anyone else want to provide some input?
 
Upvote 0
Sorry, had to shoot off for a while. What cells will be used? And what will you be putting in them?
 
Upvote 0
Not sure exactly what cells but let's say A1, A3, A5, A7, A9, A11, A13, A15. They will contain variable text data.
 
Upvote 0
So could they be anywhere on the spreadsheet, or is it in the same row, or column, or in a certain range?
 
Upvote 0
I am unsure of what the cells are but they will always be the same 8 cells, once the sheet is created. I need a message box to pop up when all 8 cells have data. It doesn't matter what we use as test data.
 
Upvote 0
OK, well I've sort of designed a little test one for you. The way I've done it is a little unorthodox. I'll mail it to you

Audiojoe

I was looking for a job and then I found a job. But heaven knows I'm miserable now
 
Upvote 0
Thanks, AudioJoe, for your help. I will look for the file to arrive in my email.
 
Upvote 0
I was making it way too hard. Your way is so simple! Thanks so much. I really appreciate your help.
 
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

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