Using one listbox to edit data from multiple worksheets

[RoroBear]

Hello All,

Reaching out for some help once again. I have a listbox that is populated from a combobox when a worksheet is selected. When I click on a selection in the listbox it populates the corresponding textboxes below. I have the below code that’s supposed to edit whatever selection I make, but instead it edits the entire table. My second problem is that it only works (if you can call it that) on one worksheet (Re-Enlistments). I want to be able to edit all the worksheets in the combobox. Code is below and file is attached. As always, I’m grateful for any assistance.

Please Login or Register  to view this content.

[Sintek]

but instead it edits the entire table.

That is because you are looping the entire tables rows

Please Login or Register  to view this content.

My second problem is that it only works (if you can call it that) on one worksheet

As you are not referencing a sheet, this code below works on active sheet only...

Please Login or Register  to view this content.

Try this to see what I mean...

Please Login or Register  to view this content.

I want to be able to edit all the worksheets in the combobox

Not all worksheets have the same info as your listbox selections though?
Are you wanting to search for criteria and update accordingly...

[karmapala]

Not so sure if I get what you want exactly,
anyway the code below is "cheating" by insert a number (for row number) to the corresponding sheet :

Please Login or Register  to view this content.

I want to be able to edit all the worksheets in the combobox

It will edit the corresponding sheet (which is selected via the combobox).
But if you mean :
the user select Re-Enlistments sheet in the combobox,
select one item in the ListBox1,
edit a value in the text-box
click the CommandButton1
then the user expecting that the edited value in the text-box is updated in Re-Enlistments sheet AND ALSO to Retirements and C-Ways sheet.....

The code don't do that, as it only updated the selected sheet via the combobox.
If the user select Re-Enlistments in the combo-box, then the updated cell (according to what's in the text box) will be just only to Re-Enlistments sheet.
If the user select Retirements in the combo-box, then the updated cell (according to what's in the text box) will be just only to Retirements sheet.
If the user select C-Ways in the combo-box, then the updated cell (according to what's in the text box) will be just only to C-Ways sheet.

[RoroBear]

first of all,

thank you for the overwhelming replies. i love this forum!!!. both suggestions work beautifully, and this may have to be a different post, but since i have everyone's attention... how to do i go the sheet or active the sheet i'm editing and show the edit in the listbox as well?

roro

[Sintek]

Just add this snippet

Please Login or Register  to view this content.

after you've updated...

[RoroBear]

brilliant!!! thank you kindly!!!

[RoroBear]

I hope i'm not wearing out my welcome, but is there a way to activate the selected sheet?

[Sintek]

Not sure where you want the snippet of code...or why you want to activate it....

Please Login or Register  to view this content.

[karmapala]

I hope i'm not wearing out my welcome, but is there a way to activate the selected sheet?

I don't exactly understand what you mean, but I guess that you want the sheet is activated once the user select the item (the name of the sheet) in the ComboBox1.

change this :

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

in combobox1_change() sub, add this line :

Please Login or Register  to view this content.

This line will activate the sheet once the item (sheet name) in the ComboBox1 is selected.

then finally in CommandButton1_Click sub :

Please Login or Register  to view this content.

This will unload the userform first, so you can see the updated text in the cell of the sheet,
then after the msgbox OK button is clicked, it will activate the "To Do List" sheet.

[RoroBear]

i wanted the worksheet to active once it's selected from the dropdown, and the codes provided did just that. thank you everyone!!! as always, really appreciate the positive feedback.

[Sintek]

Glad we could assist...Tx for rep +