Reply to topic  [ 3 posts ] 
VB in Excel 2007 
Author Message
I haven't seen my friends in so long
User avatar

Joined: Fri Apr 24, 2009 6:06 pm
Posts: 6355
Location: IoW
Reply with quote
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.

_________________
Before you judge a man, walk a mile in his shoes; after that, who cares?! He's a mile away and you've got his shoes!


Tue Apr 17, 2012 10:31 am
Profile
I haven't seen my friends in so long
User avatar

Joined: Fri Apr 24, 2009 6:06 pm
Posts: 6355
Location: IoW
Reply with quote
Nevermind. The developer tab was hidden, I should be able to muddle through now. :roll:

_________________
Before you judge a man, walk a mile in his shoes; after that, who cares?! He's a mile away and you've got his shoes!


Tue Apr 17, 2012 10:52 am
Profile
Site Admin
User avatar

Joined: Fri Apr 24, 2009 6:12 am
Posts: 7011
Location: Wiltshire
Reply with quote
Spreadie wrote:
Nevermind. The developer tab was hidden, I should be able to muddle through now. :roll:

Dead clever that isn't it?

_________________
<input type="pickmeup" name="coffee" value="espresso" />


Tue Apr 17, 2012 4:48 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.