Consulting

Results 1 to 3 of 3

Thread: Help required in replacing InputBox with Select any one option

  1. #1
    VBAX Regular
    Joined
    Nov 2020
    Posts
    49
    Location

    Help required in replacing InputBox with Select any one option

    Hi,
    Thanks for all the help extended till now to me as a beginner to VBA.
    Request help in the codes to park in my personal.xlsb to use as and when required

    (1) Replace the input box to a kind of selection from the list
    (2) Error in the code while converting large texts

    MyInput = InputBox("This is my InputBox", "MyInputTitle", "UPPER/lower/Proper/Sentense")
    Select Case MyInput
        
        Case "UPPER"
        For Each Rng In Selection
        If Application.WorksheetFunction.IsText(Rng) Then
        Rng.Value = UCase(Rng)
        End If
        Next
    Attached Files Attached Files

  2. #2
    VBAX Wizard
    Joined
    Apr 2007
    Posts
    7,475
    Location
    I think the easiest and safest and fastest way is to use a User Form

    Capture.JPG
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    VBAX Regular
    Joined
    Nov 2020
    Posts
    49
    Location
    Thanks a lot Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •