Macro to get input box with required values

• Feb 13, 2017

• #2

IDS

Civil/Environmental

Jun 1, 2001

3,291

AU

Can you attach a higher resolution copy of your image.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

Upvote 0 Downvote

• Feb 13, 2017

• Thread starter
• #3

raviprakash369

Aerospace

Mar 25, 2015

49

IN

 

Upvote 0 Downvote

• Feb 13, 2017

• #4

SkipVought

Aerospace

Jun 20, 2006

743

US

Please upload this sheet in a workbook. Many won't waste their time trying to read and transcribe a fuzzy picture.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

Upvote 0 Downvote

• Feb 14, 2017

• #5

MortenA

Chemical

Aug 20, 2001

2,998

DK

If is drop-down box with a list of values, this can be made without a macro.

If you need a VB script, try to investigate the command inputbox that would look something like this: myValue = InputBox(message, title, defaultValue)

A general help on the subject is found in excel help try to search for "form control" and look at the overview

Bets regards, Morten

 

Upvote 0 Downvote

• Feb 14, 2017

• Thread starter
• #6

raviprakash369

Aerospace

Mar 25, 2015

49

IN

Thank you Morten.

 

Upvote 0 Downvote

• Feb 14, 2017

• Thread starter
• #7

raviprakash369

Aerospace

Mar 25, 2015

49

IN

http://files.engineering.com/getfil...ile=New_Microsoft_Office_Excel_Worksheet.xlsx

 

Upvote 0 Downvote

• Feb 26, 2017

• #8

SkipVought

Aerospace

Jun 20, 2006

743

US

ravi,

It's obvious that you're way out of your league with the postings that you've made here.

First off, you have uploaded a workbook that you have not even assigned a proper name: New_Microsoft_Office_Excel_Worksheet. I would have guessed that you would at least have named it something related to tolerances.

Then I discovered that the pictures that you posted do not reflect the actual cell structure. That is very misleading! Who knows how much effort some members might have expended trying to solve a false picture of what is something different. And you apparently don't even realize that is a big problem.

Your requirement is poorly stated. What value set will define the given starting point for a process? Will it be Condition, Description or something else? From your latest thread regarding Condition 1, it makes me wonder. Your formula referenced TWO cells, B13 and C13. Where did C13 come from? Is that some unstated data element that we can't see because you just posted a picture?

You don't seem to understand what is necessary to define a requirement clearly, concisely and completely. So we will just have to say good bye.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

Upvote 0 Downvote

• Feb 27, 2017

• Thread starter
• #9

raviprakash369

Aerospace

Mar 25, 2015

49

IN

Hi SkipVought,
Sorry for the inconvenience. I will take care in future to avoid this kind of misunderstandings. Deleting this thread as the problem solved from other thread.

 

Upvote 0 Downvote

• Feb 27, 2017

• #10

IRstuff

Aerospace

Jun 3, 2002

44,904

US

As explained in the other thread, your second row is not covered by the solution presented.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

Upvote 0 Downvote