Gob Sheite
Member
Members
Forum Posts: 12
Member Since:
June 15, 2022
June 15, 2022
Offline
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: 803
Member Since:
November 1, 2018
November 1, 2018
Offline
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 803
Member Since:
November 1, 2018
November 1, 2018
Offline
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: Kathleen Silva, Xu Zhi Jie, Mary Broadstone, Dirk Veeken
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —