Any substitute for Spreadsheet control

[hsk]

Hi,
I have created a userform having one spreadsheet control. I have set it to display 2 colums and 100 rows. Users use it for entering data. My macro reads the data and processes further. this works great in 2003.

However, when this macro was shared with 2007 users, they have don't see the spreadsheet. I found out that this control is not available in 2007 (at least with std set up).

Is there any better substitute for the SS control ?

I just want to provide users a table on userform with 2 columns and 100 rows to enter inputs.

Any suggessions ?

 

[Andrew Poulsom]

It's still available for download:

http://blogs.office.com/b/microsoft-excel/archive/2006/07/17/office-web-components-roadmap.aspx

 

[hsk]

Thanks Andrew ...

But this is a utility I have developed and is going to go to n number of users which includes 2003 / 2007 users from different locations.
Downloading this meight work for me, can i do something so that it work for everybody ?
I don't want to tell user to download it and then run the utility ?
So I would rather go with some other arrangement which would work in any setup or version ....
Like adding textboxes (100 X 2). I can arrange then to look like a workbook.
This does not sound a good idea and handling 200 textboxs will only make my life difficult
any better suggessions .....

 

[Andrew Poulsom]

Sorry, I can't think of an alternative other than TextBoxes. Can't you just use a worksheet to collect the data rather than a UserForm?

 

[hsk]

Can't you just use a worksheet to collect the data rather than a UserForm?

That's an option .... Probably I will need to change the way utility works .... anyway , thanks for your inputs !!!