Passing a variable to a Worksheet at open time

N

Neil

Is it possible to pass a variabe to a worksheet as it is
opening, for instance, send a textstring, then as the
sheet opens in the worksheet_open event, tell it to
search a data table for that value and return the values
associated with it ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass value variable to worksheet event 3
In A macro create a string of variables as needed 6
Pass parameters to Workbook from hyperlink 2
Pass a worksheet as a parameter to a function? 4
Passing Criteria to a Pivot Table from combo boxes 3
Go To Cell Reference on Worksheet Open 1
Needed Macro and Function Help 4
Passing the Value of a Cell to a VBA variable. 2

Top