
Gob Sheite
Member
Members

Forum Posts: 12
Member Since:
June 15, 2022
June 15, 2022

Does anyone know what causes or restricts parameter prompts in VBA?
If you type "Application. " you will be prompted with appropriate parameters
And often you wont?
What governs whether you are prompted or not?

Velouria
London or thereabouts
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 649
Member Since:
November 1, 2018
November 1, 2018


Velouria
London or thereabouts
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 649
Member Since:
November 1, 2018
November 1, 2018

but Excel does know what the Activesheet is
Actually, no it doesn't know. When you are writing the code, the compiler doesn't know what kind of sheet will be active when the code runs. It could be a worksheet, or a chart, or a macro sheet, or a dialog sheet. That is why the ActiveSheet property returns an Object (You can check that in the Object Browser)
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852
Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
