Hi, I am fairly new to writing code in Excel, but I am using Excel with UserForms to create a config file. In this particular piece I am trying to add multiple sections to the config in the format of:
config category
I have a UserForm to collect for variables X and Y which works just fine, but I want to add the values to a column of cells in a worksheet to be later retrieved. I am not sure how to go about writing the values to a column of cells so that it starts with the "config category", ends with "end" and inserts the other three lines with the variables in between them. Anyone have any suggestions? Any help is greatly appreciated.</variable></variable></variable></variable>
config category
edit "variable X<variable x="">"
</variable>
</variable>
<variable x=""> set comment "<variable y="">variable Y"
</variable></variable>
</variable></variable>
<variable x=""><variable y=""> next
</variable></variable>
</variable></variable>
<variable x=""><variable y=""> edit "<variable x="">variable X"
</variable></variable></variable>
</variable></variable></variable>
<variable x=""><variable y=""><variable x=""> set comment "<variable y="">variable Y"
</variable></variable></variable></variable>
</variable></variable></variable></variable>
<variable x=""><variable y=""><variable x=""><variable y=""> next
</variable></variable></variable></variable>
<variable x=""><variable y=""><variable x=""><variable y="">end</variable></variable></variable></variable>
I have a UserForm to collect for variables X and Y which works just fine, but I want to add the values to a column of cells in a worksheet to be later retrieved. I am not sure how to go about writing the values to a column of cells so that it starts with the "config category", ends with "end" and inserts the other three lines with the variables in between them. Anyone have any suggestions? Any help is greatly appreciated.</variable></variable></variable></variable>