Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

**mebanet** · 08-06-2013, 04:06 AM

I need help getting the following code to work:

Please Login or Register  to view this content.

Right now I can get what I want by doing this:

Please Login or Register  to view this content.

But there are over 100 toggle buttons on my UserForm and I don't want to have to do that for every one. All my Toggle Buttons start with "tgo".

Thanks in advance

**mebanet** · 08-06-2013, 04:07 AM

oh and:

Please Login or Register  to view this content.

**Norie** · 08-06-2013, 04:11 AM

If the number after 'tgo' is the column number perhaps this.

Please Login or Register  to view this content.

**mebanet** · 08-06-2013, 05:59 AM

that didn't work, the number after tgo is the column number though... 'tgoCX10" will write to the current row column 10

**Norie** · 08-06-2013, 06:14 AM

If it's not tgo followed by the column number what is it?

Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

LinkBack

Thread Tools

Rate This Thread

Display

Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

Re: Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

Re: Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

Re: Excel VBA Code to make my Toggle Buttons output "Yes" or "No" to their cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.

Request - "write vba code on buttons to make attached user form complete"

[SOLVED] If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...

how can I make an excel cell "mark" or "unmark" when clicked on?

Insert "-" in text "1234567890" to have a output like this"123-456-7890"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions