Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Box has the focus
i have a form with several text boxes on it. let's just say TextBox1 through
TextBox5. i have Label1, which i wish to display a short help message when that textbox has the focus. the help statements are in range A1:A5. how can i translate this message into VBA: if TextBox1 has the focus then Label1.Caption = range("A1").Value TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Box has the focus
Hi Spencer
use the textbox1_Enter event e.g. Private Sub TextBox1_Enter() Label1.Caption = Range("A1").Value End Sub if you want to clear the caption put code also against the Textbox1_Exit() Cheers JulieD "Spencer Hutton" wrote in message ... i have a form with several text boxes on it. let's just say TextBox1 through TextBox5. i have Label1, which i wish to display a short help message when that textbox has the focus. the help statements are in range A1:A5. how can i translate this message into VBA: if TextBox1 has the focus then Label1.Caption = range("A1").Value TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste function is disabled when a text box has the focus | Excel Discussion (Misc queries) | |||
Text Box Focus | Excel Programming | |||
focus? | Excel Programming | |||
Text Box Set Focus Issue | Excel Programming | |||
Text Box on User Form Set Focus Issue | Excel Programming |