Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox value to worksheet
I have one CheckBox on my user form, if it is checked I want the Value Yes
(or No if the CheckBox is not selected) to go into the active row column 2 (using something like rng(1, 2).Value = ???). My macro already sets the current row as active, I just do not know how to code this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox value to worksheet
Hi,
If your are in the target cell: activecell.offset(0,0).select 'put it in column B of the current row activecell.offset(0,1).value=whatever -----Original Message----- I have one CheckBox on my user form, if it is checked I want the Value Yes (or No if the CheckBox is not selected) to go into the active row column 2 (using something like rng(1, 2).Value = ???). My macro already sets the current row as active, I just do not know how to code this. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox value to worksheet
Mark assumed that column A would be the active cell
Cells(activeCell.row,2).Value = iif(checkbox1.value,"Yes","No") might be more robust. -- Regards, Tom Ogilvy "Patrick Simonds" wrote in message ... I have one CheckBox on my user form, if it is checked I want the Value Yes (or No if the CheckBox is not selected) to go into the active row column 2 (using something like rng(1, 2).Value = ???). My macro already sets the current row as active, I just do not know how to code this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbox in a protected worksheet | Excel Worksheet Functions | |||
Checkbox to open another worksheet | Excel Discussion (Misc queries) | |||
checkbox and worksheet | Excel Discussion (Misc queries) | |||
Loop through checkBox on worksheet | Excel Programming | |||
accessing CheckBox on Worksheet | Excel Programming |