WeThotUWasAToad
asked on
Inserting additional String columns with intracellular-formatting VBA code in Excel
Hello,
Note:
This is a follow-up to several other threads related to a very cool VBA macro for Excel created by EE Expert gowflow. The code enables automated intracellular formatting in a spreadsheet.
With the code, a user can effect multiple and varying formatting changes to defined strings of characters within a cell containing a text entry. The process is shown in the upcoming screenshot where: 1) A text entry is placed in column A after which 2) two numeric values (defining the starting position and length of the string to be reformatted) are entered into one or more of 3) five pre-formatted "String" columns* depending on the desired Format (as displayed in row 2 of each column), and 4) clicking the green "Format" button which activates the macro and causes the reformatted text to appear in column L.
Any of the row-2 formats can be modified using the Format Cells > Font box and numeric values can also be changed as desired with updated results immediately appearing in column L by a repeat click of the Format button.
*As shown in the above screenshot: 1 "String" column = 2 Excel columns
Question for this thread:
How can the user insert additional String columns if more than the starting five columns are desired?
Thanks
The most recent version is attached: Intracellular-formatting-V02.xlsm
Note:
This is a follow-up to several other threads related to a very cool VBA macro for Excel created by EE Expert gowflow. The code enables automated intracellular formatting in a spreadsheet.
With the code, a user can effect multiple and varying formatting changes to defined strings of characters within a cell containing a text entry. The process is shown in the upcoming screenshot where: 1) A text entry is placed in column A after which 2) two numeric values (defining the starting position and length of the string to be reformatted) are entered into one or more of 3) five pre-formatted "String" columns* depending on the desired Format (as displayed in row 2 of each column), and 4) clicking the green "Format" button which activates the macro and causes the reformatted text to appear in column L.
Any of the row-2 formats can be modified using the Format Cells > Font box and numeric values can also be changed as desired with updated results immediately appearing in column L by a repeat click of the Format button.
*As shown in the above screenshot: 1 "String" column = 2 Excel columns
Question for this thread:
How can the user insert additional String columns if more than the starting five columns are desired?
Thanks
The most recent version is attached: Intracellular-formatting-V02.xlsm
ASKER
Works great gowflow!
I was successfully able to insert an additional String column as String 8 and change its Format cell. Then, clicking "Format" works perfectly causing the newly added Format to be applied as specified.
Note: I did get an error pop-up however, after inserting more Leading columns, but I will address that issue in the next thread.
For clarification, please note that the title (and URL) of this thread (29041815) refers to inserting additional String columns while the title (and URL) of the next thread (29041846) refers to inserting additional Leading columns.
I was successfully able to insert an additional String column as String 8 and change its Format cell. Then, clicking "Format" works perfectly causing the newly added Format to be applied as specified.
Note: I did get an error pop-up however, after inserting more Leading columns, but I will address that issue in the next thread.
For clarification, please note that the title (and URL) of this thread (29041815) refers to inserting additional String columns while the title (and URL) of the next thread (29041846) refers to inserting additional Leading columns.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you still need some help in this question ?
gowflow
gowflow
Try also Sheet1 (2) ... for a more free like format
gowflow
Intracellular-formatting-V03.xlsm