Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell to accept checkmark or "x" | New Users to Excel | |||
Inputbox with Listbox | Excel Discussion (Misc queries) | |||
insert checkmark symbol | Excel Discussion (Misc queries) |