Have designed a userform to add &/or edit data to multiple Xl worksheets. Userform has comboboxes for 'ADD' data function & a listbox to display the selected data worksheet's contents. Combobox calls a sub to select the correct worksheet & set the Listbox '.RowSource' property to display the worksheet data. Adding data works fine, & the listbox display updates on the userform automatically.
PROBLEM: re: editing data
I want to use several textboxes to display & edit data(rows) selected(eg. 'clicked') in the listbox.
Question: Is this possible with data bound to a listbox? If not what other options are available. Have tried to use code similar to that posted by Bud Delaney(6/24/02) on this message board but there is a scope(?) &/or variable passing(?) problem.
Any help would be greatly appreciated.
Thanks
PROBLEM: re: editing data
I want to use several textboxes to display & edit data(rows) selected(eg. 'clicked') in the listbox.
Question: Is this possible with data bound to a listbox? If not what other options are available. Have tried to use code similar to that posted by Bud Delaney(6/24/02) on this message board but there is a scope(?) &/or variable passing(?) problem.
Any help would be greatly appreciated.
Thanks
