Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 12, 07:21 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 3
Red face Excel worksheet questions (2)

Hi! I was able to get help with my first question and am hoping to get my last two questions answered!

I have set up a worksheet and am using it as a template for an order form - I have used data validation to create lists and the control toolbox to create check boxes and text fields.

I need to have someone explain to me (or tell me what to search for to look it up) how to do the following:

1) If a user checks a checkbox then they are required to also select a value from a drop down list. (so if they check the check box for a deluxe seat then they are required to also select a canvas color from a drop down box in the next cell)

2) If a user checks a checkbox then they are requred to also select a value from a drop down list OR type text in a text box. For example - if "change hull color" is checked - then they must select a color from a drop down list in another cell OR they must type in a custom color in the text box in another cell)

Please have pity on me - I'm not at all sure what I'm doing but I can do it if I have some help!

  #2   Report Post  
Old September 6th 12, 07:34 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by edentonmomster View Post
Hi! I was able to get help with my first question and am hoping to get my last two questions answered!

I have set up a worksheet and am using it as a template for an order form - I have used data validation to create lists and the control toolbox to create check boxes and text fields.

I need to have someone explain to me (or tell me what to search for to look it up) how to do the following:

1) If a user checks a checkbox then they are required to also select a value from a drop down list. (so if they check the check box for a deluxe seat then they are required to also select a canvas color from a drop down box in the next cell)

2) If a user checks a checkbox then they are requred to also select a value from a drop down list OR type text in a text box. For example - if "change hull color" is checked - then they must select a color from a drop down list in another cell OR they must type in a custom color in the text box in another cell)

Please have pity on me - I'm not at all sure what I'm doing but I can do it if I have some help!
Any chance of you posting what you have so far?
It's far easier to provide assistance with these issues if we have a starting point.

You'll also be more likely to receive a quick response as many people will skip over a post like this if there's nothing to work with in the first place.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need multiple IF questions & return a value from another worksheet tamij Excel Worksheet Functions 6 May 1st 09 05:24 PM
Questions about inserting an object into a worksheet Phrank Excel Discussion (Misc queries) 0 December 25th 07 09:32 PM
Opening specific worksheet from hyperlink more questions lots of questions Excel Discussion (Misc queries) 0 May 30th 07 09:53 PM
Menu-Item and worksheet deletion questions Hari Prasadh[_2_] Excel Programming 3 June 28th 05 07:41 AM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM


All times are GMT +1. The time now is 05:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017