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. :roll:

Author:  AlunD [ Tue Apr 17, 2012 4:48 pm ]
Post subject:  Re: VB in Excel 2007

Spreadie wrote:
Nevermind. The developer tab was hidden, I should be able to muddle through now. :roll:

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/