Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a combobox equal to part of a cell value
I have a cell in Sheets.(Sheet1).Range ("A1") where the content has several
digits a "/" several more digits and a "/" and then several more digits. I want a VBA that will make usftest.cmbx1.value = equal to what ever value is to the left of the first "/". I want a VBA also that will make usftest.cmbx2 = to whatever value is between the two "/"s. A final VBA to make usftest.cmbx3 = to what ever value is to the right of the second "/". Please help. -- Thanks Shawn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
make cell length always equal 10 | Excel Discussion (Misc queries) | |||
How do I make a worksheet name equal to a cell | Excel Programming | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
How do I make one cell equal to another | Excel Worksheet Functions |