LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default VBA Checkboxes

I'm using Excel 2007, but I want the code to be capable of being run
in 2003.
I have five Activex checkboxes and a non activex "go" button on an
excel sheet.
The "go" button is set to run what is in module 1. This part is
working.

What I want to do is setup 5 "if ... then" statements that are
independent of each other. I want the module 1 sub to do what it's
set to do (all working) and THEN evaluate whether a checkbox is true
or not. If it is true, I would like it to call the appropriate code
and run it.

So, for the first checkbox named work, I have put the code in a class
of it's own named class1 for now (not sure if that's where it
belongs).

What do I need to put in module 1(and declare) to evaluate the "work"
checkbox and call "class1" if the value is true and if false just move
onto the next checkbox?

In shorthand... under module 1, I want to do something like:

If work checkbox = true then run the class1 code
if next checkbox = true then run the class2 code

The code sitting in class1 works just fine when I have it under module
1 and no checkbox is being evaluated.
I can move it wherever it belongs, just not sure where that might
be.

The reason I want to call the code instead of adding it to the if then
statement is really because it's really long and I want to seperate it
for ease of adding to it later. Either way, I can't seem to get it to
evaluate a checkbox from the module... or even the worksheet when I
moved the code over there.

If this isn't clear, let me know.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Checkboxes Elaine Excel Discussion (Misc queries) 6 August 20th 09 01:41 AM
Checkboxes Robbyn Excel Programming 2 June 13th 06 06:25 PM
checkboxes mark Excel Programming 4 August 8th 04 06:23 PM
checkboxes marksuza[_3_] Excel Programming 3 December 11th 03 03:19 PM
Checkboxes Tom Ogilvy Excel Programming 0 August 11th 03 05:45 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"