+ Reply to Thread
Results 1 to 3 of 3

Userform send text box to active cell

  1. #1
    Registered User
    Join Date
    09-17-2007
    Posts
    11

    Exclamation Userform send text box to active cell

    Dear Sir / Madam,
    i am attaching a example XL sheet with a userform and i need help populating the ACTIVE CELL with data from the Userform, however the data should be concatenated with the following information:
    NJ:N=40,V6=30,V9=20

    Secondly i had researched and inserted macros to launch this userform when Ctrl+H was pressed. the macro worked but when i restarted the XL sheet it stopped working or it was sending me to another XL sheet. any help on this macro will be appreciated.

    Capture.PNG
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Userform send text box to active cell

    I'm not sure why the lower boxes would show something different.

    Here's something to work with.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-17-2007
    Posts
    11

    Exclamation Re: Userform send text box to active cell

    dear davesexcel,
    many thans fo ryour help, it works like a charm. 1 small question:
    can you please amend the code so that i can see the existing values in the cell in the active box.
    the NJ values should show in NJ boxes. and UV values in the UV boxes.
    and if i change the values in the box they should then change the active Cell. the purpose is to show any existing values so the user doesnt overwrite them by mistake and payes attention to them

    CURRENT:
    Capture.PNG

    PROPOSED:
    Capture.PNG
    Capture.PNG

    attaching sample sheet for you.
    Attached Files Attached Files

+ 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. Have Macro Send Email Only When Cell Contains Text Active
    By onelifestyle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2015, 04:14 PM
  2. Unable to send user-editable text to Outlook email body based on active cell.
    By m0meehan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-20-2014, 01:51 PM
  3. Need to send a screenshot of active userform in e-mail body
    By rsyadavsoft41 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 03:08 AM
  4. Send text from Word to active workbook/worksheet
    By silj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2013, 11:06 PM
  5. Replies: 2
    Last Post: 07-31-2012, 10:00 PM
  6. [SOLVED] Excel 2007 : Userform text box active
    By HangMan in forum Excel General
    Replies: 5
    Last Post: 07-16-2012, 02:49 PM
  7. Send email using Active Cell but using external Outlook / Livemail template
    By sellenwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2011, 12:39 AM

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