There's an article here that describes how to create a userform, and add
a check box:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
daniel chen wrote:
Hi Julie,
I am new to this. Please show me the steps
Thank you
"JulieD" wrote in message
...
Hi
only if you create a userform to display the checkboxes on ....
insert / userform from the vbe window .. put the controls on that you want
and then write code against the OK button to populate the worksheet.
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"daniel chen" wrote in message
...
Instead of
Cells(1, 1) = InputBox(prompt:=" Enter Valid entry"
Can I have a checkmark to select among many valid options in Excel.
Thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html