hitch_hiker
Active Member
- Joined
- Feb 21, 2012
- Messages
- 294
I asked something similar before , but I did not get a response. I'm looking for some guidance.
I want to press a button and get a 2 column list, first column NUMERICAL (3 or 4 digits), 2nd column STRING ( aprox 20 chars ), I want to select a row and have the numerical value entered into the next available cell in a column ( column "c" ). After the selection is made I need the list(s) to disapear.
I have tried data validation, I tried a macro which was supposed to put a combo box into the data validation box from contextures, but it didn't seem to work, I have tried combo box both form and active x as well text boxes again in both, the data entry is direct into a worksheet ( it seemed easier than into a form ). I tried to break it down into nibble size pieces and get help for each piece , but again I keep hitting brick walls
any suggestions or help ?
I want to press a button and get a 2 column list, first column NUMERICAL (3 or 4 digits), 2nd column STRING ( aprox 20 chars ), I want to select a row and have the numerical value entered into the next available cell in a column ( column "c" ). After the selection is made I need the list(s) to disapear.
I have tried data validation, I tried a macro which was supposed to put a combo box into the data validation box from contextures, but it didn't seem to work, I have tried combo box both form and active x as well text boxes again in both, the data entry is direct into a worksheet ( it seemed easier than into a form ). I tried to break it down into nibble size pieces and get help for each piece , but again I keep hitting brick walls
any suggestions or help ?
