ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   variable names stop to adapt to changes (https://www.excelbanter.com/excel-programming/406186-variable-names-stop-adapt-changes.html)

Claude

variable names stop to adapt to changes
 
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

variable names stop to adapt to changes
 
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

Claude

variable names stop to adapt to changes
 
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



All times are GMT +1. The time now is 03:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com