Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
variable file names Brettjg Excel Discussion (Misc queries) 2 March 2nd 07 10:56 AM
Variable Names in Formulas Paulo Excel Discussion (Misc queries) 2 March 29th 06 01:16 PM
How do I stop the User names in comments from appearing? Iceman Excel Discussion (Misc queries) 2 March 23rd 06 07:14 PM
Stop on variable Jos Vens[_2_] Excel Programming 5 December 11th 04 12:24 AM
Variable names in SQL Hall Excel Programming 2 May 28th 04 11:39 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"