userform

[buzz71023]

i have a sequence of userforms used to input various codes into field. That all work great and go from flawlessly, until lately. I added vbmodeless to make cells selectable on one of the forms (everything still worked great. I then added a hyperlink to that same userform (opens up a different spreadsheet for ref.) Now when I go from one userform to the one that has the hyperlink (and vbmodeless) I have to select the userform/textbox with the mouse (its lookslike something else is selected) where i didnt have to do that before.

Hopefully this is explained well enough.

(this is just to show how the one before ".show"s)
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Sheets("Data Sheet").Select
Range("Letdown").Value = TextBox1.Value
Application.ScreenUpdating = True
Unload Me
FTIRThickness.Show vbModeless
End Sub

(this is the one i am trouble with)
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Windows("Quality Control Data Sheet (BETA).xls").Activate
Sheets("Data Sheet").Select
Range("FTIRThickness").Value = TextBox1.Value
Application.ScreenUpdating = True
Unload Me
Packaging.Show
End Sub

 

[diddi]

you could add a _activate event to the userform and use .setfocus to reposition your focus back to the required textbox, which must be getting lost somehow.

 

[buzz71023]

Thanks for the advice, I'll try it tomorrow at work. My code is indented on my vbe but when I copied and pasted it onto the forum I just sent it. I wish I could box it in but have no idea how or if I can

 

[GTO]

Add tags to your code like:
[code=rich]
'your code here
[/code]

 

[buzz71023]

Thanks been wondering for a while on how to do that