DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to have a range input dialog box for user input

  1. #1
    roark Guest

    How to have a range input dialog box for user input


    writing vb code in excel of an input range dialog box where the user
    can select the range.

    What will happen is a dialog box which will
    allow the user to use the cursor to highlight the range that is required
    as the user does this action the dialog box will automatically input
    the range into the input dialog box
    or if the user wish, allow the user to enter directly into the dialog box

    the range.


    i find something similiar in excel
    Excel on the main menu goto "tools" , "Solver..."

    any clue?

    tks.
    roark

  2. #2
    Dean Earley Guest

    Re: How to have a range input dialog box for user input

    Do you want to use that control inside Excel?

    It is a custom control called ref edit, but I guess it can only be used inside Excel.

    --
    Dean Earley (dean.earley@icode.co.uk)
    Assistant Developer

    iCode Systems
    "roark" <roark@consultant.com> wrote in message news:3a9b0ff0$1@news.devx.com...
    >
    > writing vb code in excel of an input range dialog box where the user
    > can select the range.
    >
    > What will happen is a dialog box which will
    > allow the user to use the cursor to highlight the range that is required
    > as the user does this action the dialog box will automatically input
    > the range into the input dialog box
    > or if the user wish, allow the user to enter directly into the dialog box
    >
    > the range.
    >
    >
    > i find something similiar in excel
    > Excel on the main menu goto "tools" , "Solver..."
    >
    > any clue?
    >
    > tks.
    > roark




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center