thenenterthevariableasMyValuemixedcaseVBAchangesallotheroccurrencesofthe

variabletoMyValueAnexceptiontothisoccursifyoudeclarethevariablewithDimora

similarstatement;inthiswaysappearsasitwasdeclared

 

 

TheVBEditorscanstheinstructionforsyntaxerrorsIfitfindsanerroritchangesthe

colorofthelineandmaydisplayamessagedescribingtheproblemYoucansetvarious

optionsfortheVBEditorintheOptionsdialogboxaccessiblebychoosingToolsOptions

 

 

 

TipLikeExceltheVBEditorhasmultiplelevelsofUndoandRedoThereforeifyoufind

thatyoumistakenlydeletedaninstructionyoucanclicktheUndobuttonorpressCtrlZ

repeatedlyuntiltheinstructionreturnsAfterundoingtheactionyoucanchooseEditRedo

DeleteorclicktheRedoDeletetoolbarbuttontoredopreviouslyundonechanges

 

 

 

 

 

 

USINGTHEMACRORECORDER

AnotherwaytogetcodeintoaVBAmoduleistorecordyouractionsbyusingtheExcelmacro

recorderNomatterhowhardyoutryyoucannotrecordaFunctionprocedurethetypeof

procedurethatisusedforacustomwiorksehepetfunctionAllrecordedmacrosareSub

proceduresUsingthemacrorecordercanhelpyoutoidentifyvariouspropertiesthatyoucan

useinyourcustomfunctionsForexampleturnonthemacrorecordertorecordyouractions

whileyouchangetheusernameFollowthesestepsinExcel

 

ChooseDeveloperCodeRecordMacro

 

IntheRecordMacrodialogboxacceptthedefaultsettingsandclickOKtobeginrecording

TheRecordMacrobutton''scaptionchangestoStopRecording

 

ChooseExcelOptionsPopular

 

UnderthePersonalizeYourCopyofMicrosoftOfficeheadingchangethenameintheUserName

box

 

ClickOKtoclosetheExcelOptionsdialogbox