Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
Anthony's VBA Forum IndexHome Page
Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]

Not sure if it can be done

 
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA
View previous topic :: View next topic  
Author Message
i8ig



Joined: 17 Aug 2009
Posts: 1
Location: Mississippi
PostPosted: Mon Aug 17, 2009 2:51 pm    Post subject: Not sure if it can be done Reply with quote
Question I have a billing form which requires quite a bit of input, many mistakes are made. I was wondering if it is possible to create a macro to provide the user the correct input options based on information in cells? Something like If cell C7 ="SF" and cell P8="3" and cell F12 is less than 15,000 then in cell D:16 provide a drop down with 4 choices and depending on the choice provide an additional drop down with 1 to 5 choices and then place the item chosen in cell D16.

Anyone care to comment on whether this is possible and any suggestion on how to start it would be appreciated.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
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
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group