UserForm Vba code for multiple Workbooks

[sharadram1989]

Hi there,

I've tried searching of ways to do this but have not found a way.

I'm fairly new to VBA too, so please be patient if this has already something you've broken your heads over

Your help would be much appreciated!

The problem: I have data for over 100 headers, so when it comes to finding a particular header, I'm having to use the find/search function to find the particular header within the sheet or scroll across the sheet. Find search involves typing out the entire headers, which sometimes becomes tedious.

My possible solution: Was to create a Userform that has a comboBox control where you can pick the header you want from a dropdown list of headers and place a command button in the userform window which will then search this header in the relevant sheet and cells.

I know that in order for the userform to function in that particular workbook you have to input

Private Sub Workbook_Open()
"Your Userform Name".Show
End Sub


My burning question is: Is there a way of making my userform function accessible in different excel workbooks? I have many excel workbooks with these headers. So will be super handy just to press a shortcut to activate the userform function and it'll enable me to search for my header.

I have created and saved this Userform function in my PersonalVBA sheet in the hope that this can be done?

Do I have to go into each individual workbook and type the "userform.show" function?

Or is it a case that I've tried to reinvent the wheel and should just stick to the find search method?


Thanks in advance for your suggestions!

Sharad

 

[AlphaFrog]

Put your Userform in a blank workbook and save it as add-in (.xlam) file. Then add your add-in to Excel. The userform will be available to all your opened workbooks.

There are several step-by-step guides on how to make an Excel add-in. Here's one...
Easy Step-By-Step Instructions To Create Your First Excel Ribbon Add-in

 

[sharadram1989]

Thanks Alot Alphafrog. I'll try doing that instead.

How do I add it/ import it in? Is it a case of adding it in via the add in facility under the developer tab? Or some way else?

Thanks!

 

[AlphaFrog]

Thanks Alot Alphafrog. I'll try doing that instead.

How do I add it/ import it in? Is it a case of adding it in via the add in facility under the developer tab? Or some way else?

Thanks!

You're welcome.

Add or remove add-ins