Programming a toggle button
 

I am producing a worksheet form and added a toggle button that when it is
clicked, I want it to automatically fill in specific cells with "na". (The
process is to help end users skip over areas that are not applicable. I am
using an activeX toggle button control. I thought to use a checkbox but it
is too small for some of my end users to see. I don't know how to do this in
VB. Can someone help me out here?

Thanks

Programming a toggle button
 

Toggle denotes changing state forth and back.

Sounds like you just want a single use button to add n/a to a range of
cells.

Define the specific cells range then

Sub Add_na()
Range("myrange").Value = "na"
End Sub

Assign to a button from the Forms Toolbar


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 13:08:58 -0800, Frances
wrote:

I am producing a worksheet form and added a toggle button that when it is
clicked, I want it to automatically fill in specific cells with "na". (The
process is to help end users skip over areas that are not applicable. I am
using an activeX toggle button control. I thought to use a checkbox but it
is too small for some of my end users to see. I don't know how to do this in
VB. Can someone help me out here?

Thanks

Programming a toggle button
 

Thanks for the help. Will work on it today. Let's hope I can program my
first button. Frances

"Gord Dibben" wrote:

Toggle denotes changing state forth and back.

Sounds like you just want a single use button to add n/a to a range of
cells.

Define the specific cells range then

Sub Add_na()
Range("myrange").Value = "na"
End Sub

Assign to a button from the Forms Toolbar


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 13:08:58 -0800, Frances
wrote:

I am producing a worksheet form and added a toggle button that when it is
clicked, I want it to automatically fill in specific cells with "na". (The
process is to help end users skip over areas that are not applicable. I am
using an activeX toggle button control. I thought to use a checkbox but it
is too small for some of my end users to see. I don't know how to do this in
VB. Can someone help me out here?

Thanks