Prev Previous Post   Next Post Next
  #1   Report Post  
Brad
 
Posts: n/a
Default Partial input

When cell C12 = 1 , I would like the user to be able to input a value in C13
When cell C12 1, I want to control the input in C13

ie when c12 = 1 the use would enter values ranges 1 through 52
when c12 1 I would chose the appropriate number to use (again 1 through 52)

Can I have an "equation" in cell C13 to do this? I realize that the desired
result can be done using additional cells, but was wondering if it could be
done in one cell?
 
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
input box Monty Excel Discussion (Misc queries) 2 October 7th 05 08:33 AM
Input cell reference is not valid (One Variable Data Table) Dottore Excel Worksheet Functions 9 September 1st 05 03:05 PM
HOW TO PASS THE VALUE TO CORRECT INPUT BOX ? jophy j via OfficeKB.com Excel Discussion (Misc queries) 4 July 21st 05 04:09 AM
Input Form vba help mdalzell Excel Discussion (Misc queries) 0 April 8th 05 03:57 PM
can you input time (hh:mm:ss) without having to input the colon i. Lexicon Excel Discussion (Misc queries) 4 January 11th 05 02:09 PM


All times are GMT +1. The time now is 09:54 PM.

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

About Us

"It's about Microsoft Excel"