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.
Heres the part that really gets me. It works that way one time and then
wont work for several times. I cant 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.

Can you paste the code in your form? should just have something like
activesheet.cells(H16)=userform1.combobox1.text or the like
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"D Cornett" wrote:

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.
Heres the part that really gets me. It works that way one time and then
wont work for several times. I cant 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.

John,
The only code that I have for this is

Public Sub SelReqBtn_Click()
Select_Req_Form.Show
End Sub

to show the form. And

Private Sub SelReqCloseBtn_Click()
Select_Req_Form.Hide
End Sub

to hide it when I'm done. My RowSource and ControlSource are in the
properties for the ComboBox textbox. Maybe I'm going about this all wrong.



"John Bundy" wrote:

Can you paste the code in your form? should just have something like
activesheet.cells(H16)=userform1.combobox1.text or the like
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"D Cornett" wrote:

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.
Heres the part that really gets me. It works that way one time and then
wont work for several times. I cant 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.