Checkmark instead of InputBox
 

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

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

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

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

Thank you, Debra

"Debra Dalgleish" wrote in message
...
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