Posted to microsoft.public.excel.programming

Paul

external usenet poster

Posts: 661

Updating public array within a form

I have a form that requires user input to a number of boxes.

As each is updated I would like to update the array element to which it
relates.

I have stated my array as public in the code that calls the userform, but as
soon as I'm in form code I get a 'Subscript out of range' error.

Any ideas where I'm going wrong ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maintaing public array values in a user form	Chet	Excel Programming	1	October 4th 08 01:04 AM
Public array	bobbo	Excel Programming	1	October 17th 06 07:06 PM
Public Array in a form?	lux770[_3_]	Excel Programming	4	July 28th 05 08:49 AM
public array	Circe[_2_]	Excel Programming	6	May 17th 05 11:45 PM
Public Array	Brent McIntyre	Excel Programming	5	September 23rd 03 12:53 AM

All times are GMT +1. The time now is 06:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us