small dialog box for entering data to excel

[Ivar Hove]

I need to make a small dialog box with to fields, one for text and one for a
number. A next button and a finished button. I have not made many macros
before and not any containing a dialog box.

It will be used by a person who only shall enter a text and a number several
times a day, these data I want to collect in one spread sheet. So when he
have enterd a set of values and pressed next the values are placed in two
colums in a spreadsheet. And the next set of values in the next row.
Finished button saves the sheet.

But is it possible to make such a macro? And how. I start the vb editor in
excel and manage to design the dialog box i think but how to do the rest is
unkown territory for me. Anyone with a tip or ten?

Ivar

 

[Harald Staff]

Hei Ivar

Sure. Since you're a fellow countryman, send meg en epost uten noen vedlegg
til harald punktum staff krøllalfa nrk punktum no and I'll send you a small
sample file.

Best wishes Harald

 

[CLR]

Hey Harald...........

Would you be so kind as to send a copy to me also, (but in english)?
I'd like to do something similar.

Thanks,
Vaya con Dios,
Chuck, CABGx3

 

[Harald Staff]

Would you be so kind as to send a copy to me also, (but in english)?
I'd like to do something similar.

Sure. Done.

Best wishes Harald
Followup to newsgroup only please

 

[CLR]

Thank you Harald, that's very kind, and at first look it seems very neat and
exactly what I'm looking for.........

Question tho..........where might I find the code that causes the data to be
transferred to the location on the sheet that it does tho............is it
accessable?,.........is that parameter changeable?

Thanks again,
Vaya con Dios,
Chuck, CABGx3

 

[matmich]

could someone send me a copy of this file also, I to could use it
My email is (e-mail address removed)

 

[matmich]

sorry about the email address it was wrong it is (e-mail address removed)

 

[robertguy]

hi,


could you also send me the code or and example speadsheet please


my address is (e-mail address removed)


many thanks




Ro

 

[Harald Staff]

Hi Chuck

It's the "end(xlup)" line. It detects the last non-blank cell in A and adds
1 to its row number.

Everyone else: I'll email a copy to all who asked here tomorrow CET (I'm on
another pc at the moment). It's an excel file with a macro, so some
firewalls refuse to pass it through though.

Best wishes Harald

 

[Craig]

I would like a copy to please, sounds interesting.

Craig

 

[Craig]

oops forgot my email address

Craig
(e-mail address removed)

 

[CLR]

Thanks Harald...........

Sorry I didn't get back sooner, I've been "wrapped around another axel" for
a couple days.

Vaya con Dios,
Chuck, CABGx3

 

[Blh20s]

Could Harold or someone else please email me a copy of this code a
well! It would be greatly apprceiated.

My email address is (e-mail address removed)

Once again I thank you.

Bradle