Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Form is shown via an addin. User enters data into a textbox. When they exit
the textbox this code runs: Private Sub TbFaxMsg_Exit _ (ByVal Cancel As MSForms.ReturnBoolean) With Workbooks("G&H Project.xla") .Worksheets("Fax Template").Unprotect .Worksheets("Fax Template").Range("B22").Value _ = Me.TbFaxMsg.Value .Worksheets("FaxTemplate") _ .Range"B22").CheckSpelling End With With Me.TbFaxMsg .Value = Workbooks("G&H Project.xla") _ .Worksheets("Fax Template").Range _ ("B22").Value End With End Sub This seems to work, but can I suppress the message suggesting checking all the sheet, please? Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
CheckSpelling Method Continues beyond specified range | Excel Programming | |||
CheckSpelling + TextBox | Excel Programming | |||
TextBox - CheckSpelling question | Excel Programming | |||
Application.CheckSpelling Error in Macro | Excel Programming |