Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox problem
Not sure why the following code returns an Object Required Error:
If CheckBox1.Value = True Then rng(1, 6) = "Exempt" End If What I want to have happen is for the word Exempt to be placed in the rng(1, 6) when there is a check in Checkbox1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox problem
Good morning Patrick Simmonds Does this help: Range(Cells(1, 6), Cells(1, 6)) = "Exempt" Range is the command to identify a range, but you need two lots o identifiers, a start and a finish, that in this case are the same as w are identifying a single cell. HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=47164 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with checkbox control | Excel Worksheet Functions | |||
Help: weild checkbox problem | Excel Programming | |||
Problem copying checkbox values | Excel Programming | |||
Problem in adding item to a checkbox | Excel Programming | |||
Excel VBA - Userform Checkbox/Textbox Problem | Excel Programming |