Hi
I want to Show a different Userform based on the sheet its opened from. I have tried code below but the UserForm name is in the wrong format but can’t find the correct Dim, can anyone help please? The target Userform is ‘cables_form’.
Snippet:-
Tried both of these:-
I am using Excel 2000![]()
Dim form_name As String Dim form_name As UserForm sheet_name = ActiveSheet.name form_name = sheet_name & "_form" form_name.Show
Andrew
Bookmarks