Thread: Run an Add-in
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default Run an Add-in

The key phrase there is "cause...to appear". The question is WHAT
should trigger it? The routine can be in your add-in, but you'll
still need something in the workbook to trigger the event that causes
it to run. It can be as simple as putting into the "workbook open"
event, or you could attach it to a button, or any number of other ways
-- but they will depend on the nature of the routine.

On Jun 10, 2:12 pm, Byron M wrote:
What I'm trying to do is to cause a user input form I created to appear, and
then the data on the spreadsheet is processed according to the variables
input by the user. I guess where I'm having a problem is to make the form
appear ("run"). I'm able to do this by going to the VB editor, viewing the
form, and hitting run, but I'm hoping to make this a little easier for the
user....