Posted to microsoft.public.excel.programming

davesexcel[_124_] davesexcel[_124_] is offline

external usenet poster

Posts: 1

Checkbox problem

If CheckBox1.Value = True Then
Worksheets("Sheet1").Cells(23, 7).Value = 16
Else: Worksheets("Sheet1").Cells(23, 7).Value = 8
End If

this seems to work for me

--
davesexcel

------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564091

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
problem with checkbox control	Giselle	Excel Worksheet Functions	1	March 31st 06 12:57 PM
userform checkbox problem with controlsource	Pierre via OfficeKB.com[_2_]	Excel Programming	1	October 30th 05 02:32 PM
Checkbox problem	Patrick Simonds	Excel Programming	1	September 29th 05 08:47 AM
Checkbox problem	Patrick Simonds	Excel Programming	1	September 29th 05 05:37 AM
Help: weild checkbox problem	huangx06	Excel Programming	0	July 7th 05 11:13 PM

All times are GMT +1. The time now is 03:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us