How to make UserForm invoked from its parent file visible in all opened workbooks and enable selecting cells by InputBox?

Asked Aug 17 '23 at 12:38

Active Aug 17 '23 at 12:38

Viewed 17 times

I am working in Excel 365. I have a UserForm which lists all sheet names in target workbook (Name from a textbox). But the UserForm should be able to invoke from its parent file too (the file that contains the UserForm).

The problem is if I invoke the UserForm from its parent file and activate the target workbook (Name from a textbox) the UserForm stays with its parent file. I can only see the Userform if I activate its parent file or Alt + Tab. I tried as below.

ThisWorkbook.Windows(1).Visible = False
Workbooks(txtTargetFileName.Text).Activate

How can I make the UserForm visible to all the opened workbook or atleast in the target workbook and enable selecting cells by InputBox?

asked Aug 17 '23 at 12:38

Dhay

I expect you need this: https://jkp-ads.com/articles/keepuserformontop01.asp – jkpieterse Aug 17 '23 at 15:06
@jkpieterse. Looks like it will work. I will give it a try. – Dhay Aug 17 '23 at 15:23

How to make UserForm invoked from its parent file visible in all opened workbooks and enable selecting cells by InputBox?

0 Answers0