Hi,

My application runs entirely through a userform.
However, i need the user to put in data from a lot of people (employees with
their data like dat of birth, salary etc.)
I now have a button on my userform that hides the userform, shows Excel again
and shows a sheet (protected) where the user can input all the data. On the
top part of the screen, in the sheet, there is a close button to return to
the userform and make Excel invisible again.

I would like to be able to have the user put in all the data on a page in the
(multipage)userform.
Is this possible and if so, how do i go about it ?

Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

Lots of textboxes (and labels?) and a custom class to deal
with them all.

RBS

"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:576abf7fe2222@uwe...
Hi,

My application runs entirely through a userform.
However, i need the user to put in data from a lot of people (employees
with
their data like dat of birth, salary etc.)
I now have a button on my userform that hides the userform, shows Excel
again
and shows a sheet (protected) where the user can input all the data. On
the
top part of the screen, in the sheet, there is a close button to return to
the userform and make Excel invisible again.

I would like to be able to have the user put in all the data on a page in
the
(multipage)userform.
Is this possible and if so, how do i go about it ?

Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

Hi,

I think, this is not possible because the user may have to input up to 1000
employees in the userform..
Any other ideas?
Thanks,
Pierre

RB Smissaert wrote:
Lots of textboxes (and labels?) and a custom class to deal
with them all.

RBS

Hi,

[quoted text clipped - 16 lines]
Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1

Maybe a listbox or a listview (has more options) combined with just a few
textboxes to get the data in the listbox or listview. I can't see much point
in putting a workbook on a userform.

RBS


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:576f9f8e9f283@uwe...
Hi,

I think, this is not possible because the user may have to input up to
1000
employees in the userform..
Any other ideas?
Thanks,
Pierre

RB Smissaert wrote:
Lots of textboxes (and labels?) and a custom class to deal
with them all.

RBS

Hi,

[quoted text clipped - 16 lines]
Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1