Results 1 to 3 of 3

Userform send text box to active cell

Threaded View

  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

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