panmat
01-18-2012, 01:02 PM
Any help would be welcome.
I have a userform with one listbox populated with a named range (Names).
also on the form are 2 textboxes for the user to input 2 numbers.
When the user clicks OK button the selected listbox name should be looked up against the named range on the worksheet and the 2 textbox values written to the next 2 adjacent columns.
Thanks Pete
I have a userform with one listbox populated with a named range (Names).
also on the form are 2 textboxes for the user to input 2 numbers.
When the user clicks OK button the selected listbox name should be looked up against the named range on the worksheet and the 2 textbox values written to the next 2 adjacent columns.
Thanks Pete