+ Reply to Thread
Results 1 to 4 of 4

Sheet range like "A1:A2" this range autometically assign my userform's text box

  1. 08-30-2013, 06:05 AM #1
    dmanivelan
    dmanivelan is offline
    Registered User
    Join Date
    10-11-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    7

    Sheet range like "A1:A2" this range autometically assign my userform's text box

    Hi frind,
    Am develop VBA aplication. My problem is user select a
    sheet range like "A1:A2"
    this range autometically assign
    my userform's text box
    below see my screenshot.vba.JPG
    I need this kind of output please help me.
    Reply With QuoteRegister To Reply
  2. 08-30-2013, 06:38 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Sheet range like "A1:A2" this range autometically assign my userform's text box

    Hi dmanivelan,
    maybe something like this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 08-30-2013, 07:28 AM #3
    dmanivelan
    dmanivelan is offline
    Registered User
    Join Date
    10-11-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Sheet range like "A1:A2" this range autometically assign my userform's text box

    Sorry not working.
    Reply With QuoteRegister To Reply
  4. 08-30-2013, 07:32 AM #4
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Sheet range like "A1:A2" this range autometically assign my userform's text box

    Dmanivelan, could you attach the sample file where the code does not work
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. replace all defined range names in the sheet that start with "Street" to "Road"
    By matrex in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-04-2016, 08:53 AM
  2. Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell
    By madreag in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2013, 05:34 PM
  3. [SOLVED] Macro Sheet Protect Error Due to This Sub NextScreening() Range("C2").Value = Range("C
    By cychua in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-29-2012, 04:51 AM
  4. [SOLVED] Variable "sheet-name" and "range-name" wanted in INDEX/MATCH-function
    By Fiebuls in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2012, 04:09 PM
  5. How to display a "text value" after matching a "date" in a certain "date range"
    By deverom in forum Excel General
    Replies: 1
    Last Post: 09-15-2010, 01:55 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1