Using PgDn and PgUp button on MultiPage - VBA

Oseitutuakrasi

New Member
Joined
Jun 7, 2023
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Hi People,
I have managed to attach a vertical scrollbar to a page in a MultiPage control on a form (Excel VBA). So, I can move up and down using the scrollbar.
Would someone be able to show me how to use the PageDown and PageUp buttons in addition to the vertical scrollbar?

Thanks in advance
Samuel
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
I realize I have received a reply from Domenic on the above post I made yesterday (Using PgDn and PgUp button on MultiPage - VBA)
Unfortunately, I cannot read the post
Domenic, can you please resend me this post. Below is the problem I am having.
1712283514171.png
 
Upvote 0
The PgUp and PgDn buttons work within a MultiPage control once one of the following conditions are met...

1) you select/activate a control within the MultiPage control

2) you click in any area within the MultiPage control, except the page tab

3) you click on the ScrollBar itself

Does this not work for you?
 
Upvote 0
Oh I see. The PgUp and PgDn controls work as you said (I didn't know that).
Is there any way to make the Up, Down arrows work as well?

Thanks a lot!
 
Upvote 0
The up and down arrows work similiar to the PgUp and PgDn keys. Once you click/select/activate the MultiPage control, the up arrow will take you to the previous control above it, and the down arrow will take you to the next control below it.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top