Results 1 to 10 of 10

Modify a Module with a Userform?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    991

    Modify a Module with a Userform?

    Hi there everyone,

    I have an interesting question... I have an email module that sends an email from the worksheet. The Module has predetermined information.

    Is it possible for a UserForm to be used to change the data in the Module IE:


    With OutMail
            .To = "[email protected]"
            .CC = "[email protected]"
            .Subject = "Information Subject"
    
     Change data to:
    
            .To = "[email protected]"
            .CC = "[email protected]"
            .Subject = "New Information Subject"
    Regards, John
    Last edited by JJFletcher; 11-30-2021 at 01:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to use userform variables with module macro
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2019, 03:57 PM
  2. Place code in userform, module or class module
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2017, 07:04 AM
  3. [SOLVED] Value in textbox in userform to check with a dynamic range in module macro
    By flabb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2016, 05:55 AM
  4. [SOLVED] Creating a macro (or module) to modify a cell's value based on automated entries
    By Julez80s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2012, 01:51 PM
  5. Create a macro (module?) that activates in my userform code?
    By Bafa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2008, 09:15 PM
  6. accessing array of an userform from a Sheet/module macro code
    By stanigator in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2007, 09:34 PM

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