Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I click my cb1 (below) my cursor jumps inside tb1 - FINE OK
Private Sub CommandButton1_Click() Worksheets("Sheet1").TextBox1.Activate End Sub But If I type Mary -- nothing happens << but should get message Private Sub TextBox1_Change() If Not Left(Worksheets("Sheet1").TextBox1.Text, 1) = "A" Or Left(Worksheets("Sheet1").TextBox1.Text, 1) = "B" Then MsgBox "Text Input must begin with either an ""A"" or ""B"", Try Again" End If TextBox1.Text = "" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |