Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Everyone,
How do I define a variable in order to use in the initialize part of a userform. I am using John's Walkenbach's Help File example and I wanted the program to default to a certain Help File based on info provided in 1 cell. I have 4 airplanes, the airplane is selected in Cells(30,1). Based on which airplane I select gives the topic number to start off with. This is what I have below, but when I run it, I get errors, it doesn't like Airplane.Text, because I don't think it is defined anywhere??. How can I read what airplane is in the cell to select the correct topic?? (This code does NOT work) Airplane.Text = Cells(30, 1) If Airplane = "N2AJ" Then CurrentTopic = 1 If Airplane = "N9421D" Then CurrentTopic = 2 If Airplane = "N74NM" Then CurrentTopic = 3 If Airplane = "N146K" Then CurrentTopic = 4 Else CurrentTopic = 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
Userform Initialize & combo box values | Excel Discussion (Misc queries) | |||
Userform disappears when you try to initialize from a command button | Excel Programming | |||
Define variable range | Excel Programming | |||
Generic questions about variable scope the Initialize event | Excel Programming |