| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers in combo box
Hi, does anyone know a way to only allow the users to type numeric values in
a combo box and not alpha? Thanks, John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Numbers in combo box
Hi John,
I revised this from a post from Bob Kilmer on May 20 2003, 5:44 pm for textboxes Private Sub ComboBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) KeyAscii = IIf(IsNumeric(Chr(KeyAscii)), IIf(KeyAscii vbKey0, KeyAscii, vbKeyBack), vbKeyBack) End Sub Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet | Excel Programming | |||
| 20 different numbers want excel to determine which combo add to x | Excel Discussion (Misc queries) | |||
| Combo box and numbers | Excel Discussion (Misc queries) | |||
| Combo Box Values not Numbers | Excel Worksheet Functions | |||
| Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
