Toggle Button control

Bidwin · Apr 30th, 2002, 04:04 PM

I have a user form with a toggle button that, when clicked, executes a search routine on a worksheet. The button remains dimmed or opaque until I click it again. How can the button be prevented from being dimmed?
Thanks,
Bidwin

Rocky E · Apr 30th, 2002, 04:37 PM

Quote:

On 2002-04-30 10:04, Bidwin wrote:
I have a user form with a toggle button that, when clicked, executes a search routine on a worksheet. The button remains dimmed or opaque until I click it again. How can the button be prevented from being dimmed?
Thanks,
Bidwin

Well we need a little more information, please. I am puzzled as to why you are using a toggle button in the first place. Will not a simple command button do?

Really want to help, just need more details.

Rocky...

Bidwin · Apr 30th, 2002, 06:39 PM

Rocky,
I have a user form with several text boxes. Only one is available to users who enter a search argument into it. The rest are display fields for data taken from a large (>40,000 rows) worksheet. A user enters a search argument and clicks the toggle button that kicks of a search routine. If a match is found relative data is displayed on the form. If a match is not found a message is displayed saying so. The user can then quit or enter another search.

It doesn't matter what kind of control I use, I just selected the toggle button. If there's a better way please let me know.

Regards,
Bidwin

Rocky E · Apr 30th, 2002, 07:08 PM

Hi Bidwin,
I am not an expert, so I say this with humility (which is a little tough on line). A toggle is not the same. If you need a simple go search button don't use a toggle. The toggle is built to remember it's last state. That is its whole reason for being there.

Make a copy of your file. Change the button to a simple control button. If it doesn't fix your problem we can get someone smarter than me involved.

Really hope you understand I am trying to help.

Rocky...

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

Apr 30th, 2002, 04:04 PM	#1
Bidwin Join Date: Apr 2002 Posts: 27	I have a user form with a toggle button that, when clicked, executes a search routine on a worksheet. The button remains dimmed or opaque until I click it again. How can the button be prevented from being dimmed? Thanks, Bidwin

Apr 30th, 2002, 06:39 PM	#3
Bidwin Join Date: Apr 2002 Posts: 27	Rocky, I have a user form with several text boxes. Only one is available to users who enter a search argument into it. The rest are display fields for data taken from a large (>40,000 rows) worksheet. A user enters a search argument and clicks the toggle button that kicks of a search routine. If a match is found relative data is displayed on the form. If a match is not found a message is displayed saying so. The user can then quit or enter another search. It doesn't matter what kind of control I use, I just selected the toggle button. If there's a better way please let me know. Regards, Bidwin

Apr 30th, 2002, 07:08 PM	#4
Rocky E Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi Bidwin, I am not an expert, so I say this with humility (which is a little tough on line). A toggle is not the same. If you need a simple go search button don't use a toggle. The toggle is built to remember it's last state. That is its whole reason for being there. Make a copy of your file. Change the button to a simple control button. If it doesn't fix your problem we can get someone smarter than me involved. Really hope you understand I am trying to help. Rocky...