View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Soenen Ken Soenen is offline
external usenet poster
 
Posts: 25
Default Does VB have SYMBOLIC CONSTANTS similar to C/C++

Is there anything in Visual Basic that is similar to SYMBOLIC CONSTANTS as
used in the C Language. For Example, in C:

#define AAA sheet4.cells(35,6)

Sub SomeSub()

AAA = "xyz"

end sub

The compiler encounters the "#define" directive and thereafter replaces all
occurrences of "AAA" with "sheet4.cells(35,6)". So it then ends up compiling
the statement:

sheet4.cells(35,6) = "xyz"

thanks,

ken