Naming a variable using userform fields

Guessed · #3 08-18-2020, 04:08 PM

I'm not convinced you have this solved yet. Your current code actually populates the same variable (called "EVParty&EVNum") regardless of the actual values in your variables.

You have variables but are using strings of the variable names and expecting the macro to convert the string name of the variable into the variable value. Also, using a space as a separator is useless if either of the variable values contain a space - better to use something that won't appear in the values such as "|"

If you are intending to create a variable based on the values entered by the user in the userform, how are you going to make use of it in the document and/or when reopening the userform? You won't know the name of the variable to go looking for it.

I would recommend a unique location/name for this data location and if you need to store multiple values there then make them all part of a single string with a separator.

For example to write the form info to a variable

Code:

EVParty = PartyTypeList.Value
EVNum = EvidenceID.Value
ActiveDocument.Variables("FormInfo") = EVParty & "|" & EVNum & "|" & "Other stuff"

And to read these values when initialising the form

Code:

Dim sArr() as String
sArr = Split(ActiveDocument.Variables("FormInfo"),"|")
If UBound(sArr) > 1 then
  PartyTypeList.Value = sArr(0)
  EvidenceID.Value = sArr(1)
  MsgBox "Other stuff is: " & sArr(2)
End If

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show userForm from variable	Cosmo	Word VBA	5	01-31-2018 12:59 PM
Assigning a string variable to a userform label caption	Larry_1	Excel Programming	3	12-18-2017 06:59 AM
Project - variable data fields	pmarc	Word	7	04-04-2013 05:07 PM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM
Variable fields?	Emalee77	PowerPoint	0	01-30-2011 05:58 PM