Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing an index to a second workbook
Hi There,
I have one workbook with a userform & a "HelpButton" on it. I would like to open a second workbook to show the actual Help-Description. I think something should look as underneath but I don't know how I can pass the Help-index number (in my example "5") to the "Index"-variable of the 2nd wbk...! *1st Workbook Userform: Private Sub HelpButton_Click() Application.Run "help.xls!ShowUserformHelp", 5 'the 5th index in the HELP End Sub *2nd Workbook: "help.xls" : Sub ShowUserformHelp() UserForm1.Show End Sub Private Sub UserForm_Initialize() Label1.Caption = Application.VLookup(Index, HelpDescription, 2, False) End Sub All help welcome, Brgds Sige |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Workbook index | New Users to Excel | |||
Passing selected workbook name and values to a macro | Excel Worksheet Functions | |||
Passing data to an open workbook from Lotus Notes | Excel Programming | |||
Passing a Variable from Worksheet to Workbook | Excel Programming |