Get Sub Module Name using VBA and Truncate to Define Variable?

rekent · #1 08-01-2020, 07:21 AM

I have a UserForm with multiple buttons backed up by code for each individual button as follows:

Code:

Private Sub Name_Click()
  strName = "Name"
  Call ModuleName.SubName(strName)
  Unload Me
End Sub

where Name changes for each button. Rather than hardcoding strName = "Name" I would like to reference the name of the module and truncate the _Click() portion of the module name to then get the function for my strName definition. Is this something that is possible within VBA?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
DocVariable formatting and the ability to truncate a string.	MaxInCO	Word	1	12-18-2013 05:35 PM
AZWizard Module - ?hidden module	pcaldwell	Word	1	08-22-2012 01:19 PM