Macro to get input box with required values

[raviprakash369]

Hi,
Please find the below image where we need a macro to get input box to enter value and get output columns next to input.If anyone aware of this please help me.

Thanks & Regards,
Ravi

 

[IDS]

Can you attach a higher resolution copy of your image.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[raviprakash369]

 

[SkipVought]

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

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[MortenA]

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

 

[raviprakash369]

Thank you Morten.

 

[raviprakash369]

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

 

[SkipVought]

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,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[raviprakash369]

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.

 

[IRstuff]

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