D
D Cornett
I would like a single UserForm that I can use on multiple worksheets from
which the user can select from a ComboBox and pertinent data will be updated
(on the ActiveWorksheet only). The RowSource (H17:H20) and ControlSource
(H16) are the same for all of the worksheets. What I would like for it to do
is, when Sheet1 is selected and a value is selected on the UserForm, the
value chosen will be stored on Sheet1 in cell H16 and not change the value on
any of the other Worksheets.
Here’s the part that really gets me. It works that way one time and then
won’t work for several times. I can’t seem to figure out why it works
sometimes and not others. Any Suggestions?
If anyone thinks that they might be able help, I can email you a copy of the
forms if it will help.
Thanks in advance.
which the user can select from a ComboBox and pertinent data will be updated
(on the ActiveWorksheet only). The RowSource (H17:H20) and ControlSource
(H16) are the same for all of the worksheets. What I would like for it to do
is, when Sheet1 is selected and a value is selected on the UserForm, the
value chosen will be stored on Sheet1 in cell H16 and not change the value on
any of the other Worksheets.
Here’s the part that really gets me. It works that way one time and then
won’t work for several times. I can’t seem to figure out why it works
sometimes and not others. Any Suggestions?
If anyone thinks that they might be able help, I can email you a copy of the
forms if it will help.
Thanks in advance.