volabos
12-03-2007, 09:25 AM
Suppose, I have a userform and on this userform, I have a listbox, name it listbox1, containing 4 elements : A, B, C, and D.
However instead of working directly with A, B, C or D, user might want to work with their simple functions.
For example he may want to work with A, B, A-D, A-C. Therefore i have to "invent" some way so that user can enter those choices.
I thought of following:
On the same userform, just beside of listbox1, there will be a textbox. But user can not write anything by using keyboard, except the mathematical signs. He will only have choice to enter data from the listbox1 entries.
Fo the current example, in that textbox user can write : A,B,A-D,A-C. Here he will take A, B etc from listbox1 and '-' ',' signs can be entered through keyboard.
Can anyone help me to write a VBA code for doing this job? Your help will be highly appreciated.
Thanks and Regards,
:banghead:
However instead of working directly with A, B, C or D, user might want to work with their simple functions.
For example he may want to work with A, B, A-D, A-C. Therefore i have to "invent" some way so that user can enter those choices.
I thought of following:
On the same userform, just beside of listbox1, there will be a textbox. But user can not write anything by using keyboard, except the mathematical signs. He will only have choice to enter data from the listbox1 entries.
Fo the current example, in that textbox user can write : A,B,A-D,A-C. Here he will take A, B etc from listbox1 and '-' ',' signs can be entered through keyboard.
Can anyone help me to write a VBA code for doing this job? Your help will be highly appreciated.
Thanks and Regards,
:banghead: