Grid On User Form

[JoeMicro]

Hi
i m trying to create a UserForm where the user will be able to enter several lines of data, and it should be analyzed with some code and posted to the appropriate sheet.

Would anybody know what is the best control to use for this?

Thanks

Joe

 

[SkipVought]

Hi,

Take a look at Microsift Office Spreasheet

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[JoeMicro]

Thanks Skip
i Did

But i don't really get how it works,

i would like to do a validation list in one column?

and where could i read up on how to reference it in VBA?

Thanks

 

[SkipVought]

What have you tried?

Post the code that you are having trouble with.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[JoeMicro]

i didn't do any code yet
i don't know where to start?

 

[mintjulep]

Start with a clear problem definition.

 

[fumei]

i didn't do any code yet
i don't know where to start?"

How can you even have a userform at all without having some code?

Do you even have a userform to start with? I have to agree with mintjulep's comment, as a basis for ALL projects. Start with a clear definition of your requirements.

faq219-2884

Gerry
My paintings and sculpture