I'm preparing a Userform with plenty Textboxes and one listbox. I've apllied class module for all textboxes in Userform and when writing (change event) words at selected textbox I get dinamically updated listbox showing me possible words combination. Words shown in listbox are placed at worksheet. Now comes the problems. I want to click a word(value) from Listbox and automatically place that word(value) in selected textbox (textbox that click at the beggining). I've tried to declare a public variable to catch the name ** clicked textbox and then when selecting value from listbox, place that value to textbox variable name, but it doesn't work. What I'm doing wrong? Is it possible to create such a variable that storage Class module controls names and them easily refer to them when clicking any ** them?

Please Login or Register  to view this content.
thanks for help, it drives me crazy
If useful I'll attach a file