ExcelBanter - Passing a variable to a Worksheet at open time

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Passing a variable to a Worksheet at open time (https://www.excelbanter.com/excel-programming/277418-passing-variable-worksheet-open-time.html)

neil

Passing a variable to a Worksheet at open time

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 ?

All times are GMT +1. The time now is 08:59 AM.