Userform- data access/data editing

rg

New Member
Joined
Oct 18, 2002
Messages
12
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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,144,112
Messages
5,722,544
Members
422,446
Latest member
jsasiadek35

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top