roofing program using user forms

toecutter

New Member
Joined
Nov 8, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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

Active Member
Joined
Mar 13, 2004
Messages
371
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,994
Members
412,633
Latest member
simon_elvin
Top