Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am setting up a userform and have placed a Combobox on it.
I want it to list Numerical values ONLY from a sheet named "Data Sheet for Inspections", in Colum "A". As data is input the Column and over time, there will only be a text value of "Roll#" AND an Numerial Value Custom Formatted as "#123". IE. Hash in front of the value. There will be a 3 digit numerical value every 25 rows or so, and a text value of "Roll#" above it, ALL other cells in Column "A" will be left blank. So, is ther a way to fill the combobox with ONLY the numerical values in this sheet in column A, EXCLUDING the Text AND EMPTY Cells ? How ? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I give numerical values to each text item in a list | Excel Discussion (Misc queries) | |||
Using Unique Values in as a combobox value list | Excel Discussion (Misc queries) | |||
Extracting data/numerical values from a give list | Excel Programming | |||
if specific value from list A equals one of the values from list b... | Excel Worksheet Functions | |||
how to populate a combobox with a list of unique values? | Excel Programming |