Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new at this so please be easy on me. I'm using MS Excel 2000
My problem is I'm tring to extract user information from a Combination drop down-edit box from the Userform/dialogsheet and place it on a spredsheet. The cell link for the list control works fine but when the user enters data that is not in the list I need to extract it. the code I've been using works fine for a editbox, but does not work for the Combination box. I'm sure it's just a "KeyWord" Issue, but I'm at a lost for it. I was using the "keyword" EditBox for extracting the infomation for the edit box what would it be for the Combination drop down-edit box? Sample Code: Sheets("{Sheet Name}").Select Range("{Cell Name}").Value = DialogSheets("{dialogsheet name}").EditBoxes("{Control Name}").Text Thanks.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit Drop Down List | Excel Worksheet Functions | |||
Edit Drop down box | Excel Discussion (Misc queries) | |||
"combination drop-down edit " form activation in Excel | Excel Discussion (Misc queries) | |||
edit a drop down list | Excel Discussion (Misc queries) | |||
How to create a "combination drop-down edit" box? | Excel Programming |