VBA variable object names

[nick1408]

Not sure if this is possible.

I have a userform with several line items. The text fields on each line carry names like Title1, Edition1, Title2, Edition2 etc. I want to call sub that will change the number in the field name. I tried the following:

dim lineNumber as string
lineNumber = 1
Call CreateForm

lineNumber = 2
CallCreateForm

sub CreateForm()

if Title & lineNumber.Value <> "" then

' code here

end if

end sub

I also tried "Title" & lineNumber but had the issue that the object name isn't seen as Title1, Title2 etc. Is there a way to have variable field names to run the VBA code?

Thanks in advance.

 

[nick1408]

All good now - I have this working another way:

dim lineNumber as string
lineNumber = 1
Call CreateForm

lineNumber = 2
CallCreateForm

sub CreateForm()

fieldName = "Title" & lineNumber
nextField = "Edition" & lineNumber

if Title & fieldName.Value <> "" then

' code here

end if

end sub