Posted to microsoft.public.excel.programming

external usenet poster

Posts: 61

checkbox code needed

I have 3 checkboxes on a userform. The Userform is opened if anycell in
range C4:C100 is selected. Checkbox 1 if true = "Mech", Checkbox 2 if true =
"Elect" and Checkbox 3 if true = "Inst/FET".
I need some code so that if for example Checkbox 1 and 2 are true, then
Activecell.offset (0,9) is returned with Mech & Elect.
Similiarly, if Checkbox 1, 2 and 3 are true it returns Mech & Elect &
Inst/FET.
I need this to work in all combinations. Is it possible?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
checkbox and textbox help needed	pswanie	Excel Programming	0	July 17th 08 08:26 AM
checkbox help needed	pswanie	Excel Programming	0	July 16th 08 11:22 PM
Help with checkbox code	Mekinnik	Excel Programming	1	October 16th 07 08:40 PM
help in checkbox code	Soniya[_4_]	Excel Programming	1	April 24th 05 01:49 PM
Checkbox Code	Edwin Tam[_2_]	Excel Programming	0	January 14th 04 02:26 AM

All times are GMT +1. The time now is 01:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us