roofing program using user forms

[toecutter]

hi
iam a professional estimator and use excel for estimating metal roofing products.
Iam trying to make a simple to use roofing program using user forms to input data into a excel spreadsheet.
i have no prblem making the forms but the code is beyond me
would anyone be interested in helpin me?
toe

 

[BrianB]

The coding is fairly easy.

With a row number variable (say FromRow) , to get data into a form we use the Initialise event with code like
TextBox1.Value =ActiveSheet.Cells(FromRow,1).Value

and to put the revised data back to the worksheet in code for a button
ActiveSheet.Cells(FromRow,1).Value = TextBox1.Value

 

[chicagodiceman]

Toecutter

I received your private message and sent you an email but it has bounced back. Yes, I've worked on this kind of project and if you'll provide me with what you have so far and what you think you'll need, I'll help in whatever way I can.

 

[Smitty]

Welcome to the Board!

Why recreate the wheel? OZGrid's Roofing Estimator

It's pretty slick.

Smitty