Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
|
im trying to make a new quote type thing at work to replace the spreadsheet type thing. what im after is so that first off all you get a box pop up asking for the name of the insured, you write that in and then it places that in a spreadsheet in a certiain cell, then want questions like 'building sum insured' and you put the figure in and press ok and it puts it in spreadsheet...
im sure its possible as i 'think' i did something like this at 6th form 
any ideas?
|
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
|
Formula, do you mean having a set form on excel, that when you enter a name it automatically puts the name into ... e.g cells B4?
|
Darren
Member
Registered: 21st Apr 02
Location: Hadleigh, Suffolk
User status: Offline
|
quote:
Originally posted by Ally
Formula, do you mean having a set form on excel, that when you enter a name it automatically puts the name into ... e.g cells B4?
yeah, and i think its got something to do with macros.
i already have a quote sheet in excel with all formulas etc im just bored so was gonna try tart it up lol
|
VegasPhil
Premium Member
Registered: 16th Jan 05
Location: Fareham, Hants Drives: Octavia VRS
User status: Offline
|
You want Macros and Visual Basic. That's what you use to make a form. I'll try and i know to draw a button you use the Forms Toolbar and then draw a button onto the spreadsheet...
Corsa 2.0 16v Vegas - Sold
|
