Joined: 17 Aug 2009 Posts: 1 Location: Mississippi
Posted: Mon Aug 17, 2009 2:51 pm Post subject: Not sure if it can be done
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.
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