Userform Capabilities

[Pete]

I want to create a userform that looks alot like a blank
excel spreadsheet. With grid lines and colum headings. Is
this possible?

If possible I want to be able to input info into the
userform and extract the info into seperate worksheet in
given order. The purpose of the userform is to limit the
accesibility of the user to a limited sector of the
spreadsheet.

When the user hits the button to calculate the info a
macro will run input the info where it belong, save and e-
mail the file back to me and shut the program down
completely.

Again is this possible?
Pete

 

[Dick Kusleika]

Pete

There is a FlexGrid control which somewhat emulates a spreadsheet. You have
to have (I think) the Developer's Edition of Office or Visual Studio 6 in
order to be licensed to use it.

Having said that, I cringe at recreating spreadsheets in userforms. Excel
already is a spreadsheet program, so why write your own? I think you should
endeavor to use Excel's builit in spreadsheet interface along with
protecting cells, the EnableSelection property of the Worksheet object, and
hiding rows and columns.

Post back with some specifics if you need some ideas on how to restrict
entry.