ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loading Data into MultiPage UserForm (https://www.excelbanter.com/excel-programming/441225-loading-data-into-multipage-userform.html)

hawk

Loading Data into MultiPage UserForm
 
Good evening: I am a novice at VBA, though have written some code through
trial and error. I now am trying to find the best way to fill combo and list
boxes on a multi-page (3 page) form with boxes on each page. I assume this
would best be done in the form_initialize code, but I'm struggling with the
process of changing pages to load the data.

Could someone provide some basic code showing this?

Thanks...

ozgrid.com

Loading Data into MultiPage UserForm
 
Name the Range(s) then type the Name in the RowSource/ListRange Property at
design time.


--
Regards
Dave Hawley
www.ozgrid.com


"Hawk" wrote in message
...
Good evening: I am a novice at VBA, though have written some code through
trial and error. I now am trying to find the best way to fill combo and
list
boxes on a multi-page (3 page) form with boxes on each page. I assume
this
would best be done in the form_initialize code, but I'm struggling with
the
process of changing pages to load the data.

Could someone provide some basic code showing this?

Thanks...




All times are GMT +1. The time now is 09:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com