Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I spent what seemed a lifetime learning excel macro language and now think
its about time I embraced this new fangled vb code. I cannot seem to grasp how error checking works in vb, it was so simple in macro language. I'm sure its as simple in vb, but I need some guidance. Can somebody please help with the vb code for the following macro4 code. A1=SELECT("Range_1") A2=ERROR(FALSE) A3=FORMULA.FIND("Something") A4=IF(A3=TRUE,GOTO(A7)) A5=ALERT("Not found") A6=HALT() A7=ALERT("Found") A8=HALT() |
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) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
option buttons run Click code when value is changed via VBA code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |