Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hallo,
programing Excel-sheets, my VB 6.5 editor suddenly begins to behave strangely, i.e. when I change the spelling of a variable after DIM the same variables within the sub-routine won't change accordingly as they used to do. For example: DIM intNumbr AS INTEGER ... intNumbr = 5 When I used to correct into DIM intNumber AS INTEGER all other lines would change automatically like intNumber =5 This helpful feature just stopped working and I do not find any checkbox under Options or anywhere to make it work again. Any suggestions? Thanks a lot. Claude -- Claude |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think you're mis-remembering.
If you change the case (not spelling) of intNumbr, then all the other occurrences will reflect that change. If you really change the spelling, then maybe you can just use a nice Edit|Replace to change the others. Claude wrote: Hallo, programing Excel-sheets, my VB 6.5 editor suddenly begins to behave strangely, i.e. when I change the spelling of a variable after DIM the same variables within the sub-routine won't change accordingly as they used to do. For example: DIM intNumbr AS INTEGER ... intNumbr = 5 When I used to correct into DIM intNumber AS INTEGER all other lines would change automatically like intNumber =5 This helpful feature just stopped working and I do not find any checkbox under Options or anywhere to make it work again. Any suggestions? Thanks a lot. Claude -- Claude -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Dave, you are right, it is just the change of case which is adopted.
Kind of memory-crash on my side... sorry. -- Claude "Dave Peterson" wrote: I think you're mis-remembering. If you change the case (not spelling) of intNumbr, then all the other occurrences will reflect that change. If you really change the spelling, then maybe you can just use a nice Edit|Replace to change the others. Claude wrote: Hallo, programing Excel-sheets, my VB 6.5 editor suddenly begins to behave strangely, i.e. when I change the spelling of a variable after DIM the same variables within the sub-routine won't change accordingly as they used to do. For example: DIM intNumbr AS INTEGER ... intNumbr = 5 When I used to correct into DIM intNumber AS INTEGER all other lines would change automatically like intNumber =5 This helpful feature just stopped working and I do not find any checkbox under Options or anywhere to make it work again. Any suggestions? Thanks a lot. Claude -- Claude -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variable file names | Excel Discussion (Misc queries) | |||
Variable Names in Formulas | Excel Discussion (Misc queries) | |||
How do I stop the User names in comments from appearing? | Excel Discussion (Misc queries) | |||
Stop on variable | Excel Programming | |||
Variable names in SQL | Excel Programming |