Get value from textbox and use it inthe form of Array

AkshayRM

New Member
Joined
Jun 22, 2020
Messages
9
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
Get value from textbox and use it in the form of Array.

So basically what I am doing is,converting fixedwidth file.
I recorded a Macro for that. And delimiting the values. And the below value I am getting from userform. (Bold and underlined)
. TextFileFixedColumnWidths = Array(3, 5, 8, 8, 13...)
so user will enter values in text box like- 3 ,5, 8, 8, 13...)
Now I declared a variable.
Dim delimitvalues As Variant
delimitvalues = UserForm1. Textbook. Value
And then code
.
.
.
. TextFileFixedColumnWidths = Array(delimitvalues)

but this is not working it's shows error-Run time error 5 (Invalid procedure call or argument)
what I understand is it's taking as string and not as array.

Even I tries to remove double quotes by
delimitvalues=Replace(delimitvalues, Chr(34), "")

I tried this also
MyZeroBasedArray = Split (delimitvalues, ", ")

but nothing worked.
please help me on this with whichever method possible.


I hope my question is clear pleas let me know i will clarify.
 

AkshayRM

New Member
Joined
Jun 22, 2020
Messages
9
Office Version
  1. 2016
  2. 2010
Platform
  1. Windows
Wow, I never thought in that way.
It's working. Thank you once again. :)
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,903
Office Version
  1. 365
Platform
  1. Windows
Glad to help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,478
Members
412,595
Latest member
slim313
Top