+ Reply to Thread
Results 1 to 3 of 3

show userform when i move a shape from one column to another

  1. #1
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    show userform when i move a shape from one column to another

    Hii!!
    I have two columns in my worksheet where i have to move shapes inserted anywhere in column 1 to column 2.
    whenever i do so i want a userform to appear in my sheet. There is only one text box and one submit button in userform.
    whatever data i insert in that textbox that gets saved in sheet3 column B.
    Attached Files Attached Files
    Last edited by Awni; 06-22-2016 at 02:49 AM.

  2. #2
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: show userform when i move a shape from one column to another

    Thanks in advance
    Last edited by Awni; 06-22-2016 at 02:50 AM.

  3. #3
    Registered User
    Join Date
    06-14-2016
    Location
    Bangalore,India
    MS-Off Ver
    2007
    Posts
    26

    Re: show userform when i move a shape from one column to another

    Hello Everyone...
    Please see the worksheet i attached.

    Mr Jaafar Tribak helped me with the code. and i modified my sheet.
    what i wanted to do is When I move any Rectangle From "In Work" Lane to "Closed" Lane,
    Or Created lane to Closed lane, The userform named - "completed" should appear.The userform is already designed in vba.
    And whatever data I enter in the userform it should get saved in Sheet3. (Column B)

    Mr Jaafar Tribak code is
    Please Login or Register  to view this content.
    I need a little more modification with the code which i explained in the worksheet i attached... And then the problem is solved.
    The code I Entered in "This workbook" is doing what I want. but It is working only when I select a shape in "Created"
    lane and then move the rectangle to "Closed" Lane.
    I want the userform to appear whenever I move any shape from Created / InWork Lane to Closed lane Without having to run the
    macro everytime I select the shape I want to move.
    Please tell me what more modification should I do with the code…
    Last edited by Awni; 06-22-2016 at 03:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Userform textfield to show the max value from a column
    By qclady in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2015, 08:17 PM
  2. [SOLVED] Userform - move column according to combobox selection
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2014, 11:39 AM
  3. Move Shape Other Shape Stays Within It
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2014, 01:18 PM
  4. How to show a chart with a shape on a userform using VBA
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2013, 01:12 PM
  5. Userform Combobox - Show 2 columns Use data from 2nd Column
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2011, 03:26 PM
  6. Macro to move a shape once and move it back again on sequential presses.
    By ynot2010 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-14-2010, 07:05 AM
  7. [SOLVED] How do I get a column heading to show up at the top and not move .
    By Need help guy in forum Excel General
    Replies: 2
    Last Post: 02-24-2005, 04:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1