| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why did XL stopped showing me the Macro Commands List
I must have done something wrong. While I was in the VBE Editor working on a
macro, Excel2000 used to show me suitable commands as I type in...Now suddenly it stopped. I'd appreciate if someone help me correct this. TIA Martyn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
In the VBE, Click Tools--Options. On the Editor Tab check "Auto List
Members" -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Martyn" wrote in message ... I must have done something wrong. While I was in the VBE Editor working on a macro, Excel2000 used to show me suitable commands as I type in...Now suddenly it stopped. I'd appreciate if someone help me correct this. TIA Martyn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Thanks Robert but "Auto List Members" is already checked.
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Martyn,
I suppose you at the same time checked Auto Quick Info as well ? That the component that's deciding about "adding the tips to your command typing". -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Regards A.W.J. Ales,
Thanks for your reply. All Edit options were checked, including: ------------- Auto Syntax Check Require Variable Declaration Auto List Members Auto Quick Info Auto Data Tips --------- I removed the check from "Auto Quick Info" and try to type a command. It make no changes... What should be the "ideal" checked position of all options under Tools Options in VBE Editor?. I may have made a mess out of the settings... Martyn "A.W.J. Ales" wrote in message ... Martyn, I suppose you at the same time checked Auto Quick Info as well ? That the component that's deciding about "adding the tips to your command typing". -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Martyn,
I don't know what YOUR ideal checked position would be. As far as my setup is concerned, everythinh on the Editor Tab is checked and I've set the Tab width to 3. From this I think only Require Variable Declaration you should consider to be *needed* to to be checked, but actually I should check everyone of them. -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Martyn" wrote in message ... Regards A.W.J. Ales, Thanks for your reply. All Edit options were checked, including: ------------- Auto Syntax Check Require Variable Declaration Auto List Members Auto Quick Info Auto Data Tips --------- I removed the check from "Auto Quick Info" and try to type a command. It make no changes... What should be the "ideal" checked position of all options under Tools Options in VBE Editor?. I may have made a mess out of the settings... Martyn "A.W.J. Ales" wrote in message ... Martyn, I suppose you at the same time checked Auto Quick Info as well ? That the component that's deciding about "adding the tips to your command typing". -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
2 more things to try:
1. Use the Debug--Compile command to see if your code runs into any problems. If it does, fix the problem(s) until the command yields no errors. Then try lising the members. 2. Reboot your machine. -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Hi Robert,
Thanks for your post. It is good to be replied by a Microsoft MVP - Excel. But what exactly am I to do in order to "try lising the members"? "Robert Rosenberg" wrote in message ... 2 more things to try: 1. Use the Debug--Compile command to see if your code runs into any problems. If it does, fix the problem(s) until the command yields no errors. Then try lising the members. 2. Reboot your machine. -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Martyn,
Does CTRL+Spacebar bring up the list of items? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Martyn" wrote in message ... Hi Robert, Thanks for your post. It is good to be replied by a Microsoft MVP - Excel. But what exactly am I to do in order to "try lising the members"? "Robert Rosenberg" wrote in message ... 2 more things to try: 1. Use the Debug--Compile command to see if your code runs into any problems. If it does, fix the problem(s) until the command yields no errors. Then try lising the members. 2. Reboot your machine. -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Do you declare you variables as
Dim rng as Range Dim nm as Name If you don't, then you won't get any intellisense because Excel doesn't know what type of variable they are. You only get intellisense on typed variables. Of course if you are getting nothing at all, then that wouldn't be the problem. -- Regards, Tom Ogilvy "Martyn" wrote in message ... Hi Robert, Thanks for your post. It is good to be replied by a Microsoft MVP - Excel. But what exactly am I to do in order to "try lising the members"? "Robert Rosenberg" wrote in message ... 2 more things to try: 1. Use the Debug--Compile command to see if your code runs into any problems. If it does, fix the problem(s) until the command yields no errors. Then try lising the members. 2. Reboot your machine. -- __________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Martyn" wrote in message ... Thanks Robert but "Auto List Members" is already checked. |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Try my solution posted in misc
-- Don Guillett SalesAid Software "Martyn" wrote in message ... I must have done something wrong. While I was in the VBE Editor working on a macro, Excel2000 used to show me suitable commands as I type in...Now suddenly it stopped. I'd appreciate if someone help me correct this. TIA Martyn |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why did XL stopped showing me the Macro Commands List
Thanks Don, posted my reply there...
"Don Guillett" wrote in message ... Try my solution posted in misc -- Don Guillett SalesAid Software "Martyn" wrote in message ... I must have done something wrong. While I was in the VBE Editor working on a macro, Excel2000 used to show me suitable commands as I type in...Now suddenly it stopped. I'd appreciate if someone help me correct this. TIA Martyn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel 2000 work sheet excel commands are showing how to rectif | Excel Worksheet Functions | |||
| Why has Excel stopped showing colour changes to fonts & text? | Excel Discussion (Misc queries) | |||
| Excel has stopped showing graphs on seperate chart tabs | Charts and Charting in Excel | |||
| Filtering a column, where it stopped showing records | Excel Worksheet Functions | |||
| Why did XL stopped showing me the Macro Commands list? | Excel Programming | |||
Hybrid Mode
