Checkmark instead of InputBox

[daniel chen]

Instead of
Cells(1, 1) = InputBox(prompt:=" Enter Valid entry"
Can I have a checkmark to select among many valid options in Excel.
Thanks

 

[JulieD]

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.

 

[daniel chen]

Hi Julie,
I am new to this. Please show me the steps
Thank you

 

[Debra Dalgleish]

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]

Thank you, Debra

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