x404.co.uk http://www.x404.co.uk/forum/ |
|
VB in Excel 2007 http://www.x404.co.uk/forum/viewtopic.php?f=3&t=16290 |
Page 1 of 1 |
Author: | Spreadie [ Tue Apr 17, 2012 10:31 am ] |
Post subject: | VB in Excel 2007 |
Can one of you kind people tell me how to create VB forms in Excel 2007? I haven't done this kind of thing in years, and cannot find my way around Excel as easily as I used to. Looking to create a simple form for the sales team to work out quantities of materials, based on area/volume and relative density. The calculations are easy, but I have no idea where to start designing a form. [edit] you used to be able to create a simple grey form and add buttons, text boxes and entry fields and create functions/calculations for different fields. This is what I'm having trouble finding. |
Author: | Spreadie [ Tue Apr 17, 2012 10:52 am ] |
Post subject: | Re: VB in Excel 2007 |
Nevermind. The developer tab was hidden, I should be able to muddle through now. ![]() |
Author: | AlunD [ Tue Apr 17, 2012 4:48 pm ] | |||||||||
Post subject: | Re: VB in Excel 2007 | |||||||||
Dead clever that isn't it? |
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |