[oldsmokey]

Hi all
I am working on a small project at the moment and I am having a problem with a userform I have created. If anyone can provide me with some guidance/solution, that would be great.
The userform consists of the following:
1 x Multipage with 2 tabs
13 x text boxes with 2 being set to multiline
4 x comboboxs
1 x button (Close)
(all the above on the first page, 2nd page not yet developed)
Each of the above have had their controlsource set to the underlying spreadsheet. When I run the form and start inputting information, the values do appear in the correct cells, but before I can finish the form, my CPU starts running at 90% or more and effectively freezes the form.
The only code I have so far is to initialize the combo boxes. I have checked the various text boxes etc but cannot find any issue !!

I would appreciate any assistance with this one.

thanks
oldsmokey

[Rollin_Again]

Can you duplicate the problem on another machine using the exported form?

Regards,
Rollin

[oldsmokey]

Hi

I have not exported the form but took a copy of the spreadsheet a few days back and tried it on another PC, the same problem happened on that PC as well. I try the export though. Is there a limit to how many controls you can have on a form, I wouldn't have thought so.

thanks
old smokey

[oldsmokey]

Hi Rollin_Again

I've exported the form to another machine and I still get the same problem. Not sure what is going on. I've attached the userform if you would like to see it, maybe I have an incorrect setting somewhere, I can't find it.

thanks
oldsmokey

[Rollin_Again]

I am getting errors when I try to open your form in both Excel and VB 6.0

Are you able to post or email your workbook with the form already inserted?

Regards,
Rollin

[oldsmokey]

Hi Rollin

Here you go. Hopefully you can open this.

thanks
oldsmokey

[slurpee55]

I didn't really get the errors you described, although it did take a lot of memory.
Personally, I would be more likely to build this in Access - the forms are as neat and all the data is stored together.

[oldsmokey]

Hi all

Been working on this form and found that the controlsource is causing my problems. So I have not set them for the various text/combo boxes and decided instead to write the values to the cells when I press the 'Close' button after filling them in at the end. This seems to do the trick for me.

Thanks for all your help.

regards
old smokey