Controls and VBA help

wilkisa · Apr 18th, 2002, 05:43 AM

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

Audiojoe · Apr 18th, 2002, 06:25 AM

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 ]

wilkisa · Apr 18th, 2002, 06:32 AM

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?

Audiojoe · Apr 18th, 2002, 07:34 AM

Sorry, had to shoot off for a while. What cells will be used? And what will you be putting in them?

wilkisa · Apr 18th, 2002, 07:37 AM

Not sure exactly what cells but let's say A1, A3, A5, A7, A9, A11, A13, A15. They will contain variable text data.

Audiojoe · Apr 18th, 2002, 07:38 AM

So could they be anywhere on the spreadsheet, or is it in the same row, or column, or in a certain range?

wilkisa · Apr 18th, 2002, 07:43 AM

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.

Audiojoe · Apr 18th, 2002, 07:45 AM

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

wilkisa · Apr 18th, 2002, 07:49 AM

Thanks, AudioJoe, for your help. I will look for the file to arrive in my email.

wilkisa · Apr 18th, 2002, 08:00 AM

I was making it way too hard. Your way is so simple! Thanks so much. I really appreciate your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 05:43 AM	#1
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	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

Apr 18th, 2002, 06:25 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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 ]

Apr 18th, 2002, 06:32 AM	#3
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	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?

Apr 18th, 2002, 07:34 AM	#4
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Sorry, had to shoot off for a while. What cells will be used? And what will you be putting in them?

Apr 18th, 2002, 07:37 AM	#5
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	Not sure exactly what cells but let's say A1, A3, A5, A7, A9, A11, A13, A15. They will contain variable text data.

Apr 18th, 2002, 07:38 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	So could they be anywhere on the spreadsheet, or is it in the same row, or column, or in a certain range?

Apr 18th, 2002, 07:43 AM	#7
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	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.

Apr 18th, 2002, 07:45 AM	#8
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	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

Apr 18th, 2002, 07:49 AM	#9
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	Thanks, AudioJoe, for your help. I will look for the file to arrive in my email.

Apr 18th, 2002, 08:00 AM	#10
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	I was making it way too hard. Your way is so simple! Thanks so much. I really appreciate your help.