INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Macro to get input box with required values

Macro to get input box with required values

(OP)
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

RE: Macro to get input box with required values

Can you attach a higher resolution copy of your image.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Macro to get input box with required values

(OP)

RE: Macro to get input box with required values

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Macro to get input box with required values

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

RE: Macro to get input box with required values

(OP)
Thank you Morten.

RE: Macro to get input box with required values

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Macro to get input box with required values

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close