http://www.babyclothingboutique.net/latest-loop/
How do you assign a new variable to a selection during a loop and then recall that variable’s value later?
will call the new variables with msgbox at the end of the macro.
can’t create variables initially because i don’t know how many variables i will need. it will vary. therefore i need to create the variable as it is needed to store a value.
question #2 is there a way to display those values in a msgbox without having to input every single value?
EXCEL VBA
will call the new variables with msgbox at the end of the macro.
can’t create variables initially because i don’t know how many variables i will need. it will vary. therefore i need to create the variable as it is needed to store a value.
question #2 is there a way to display those values in a msgbox without having to input every single value?
.
You want to use an array.
http://www.eng.wayne.edu/~robert/be1010/fall02/VBAArrays.htm
|
|
NWT,Latest HOT Mens X-Loop sunglasses,Black and Blue frame,mirror lens,100%UVA&B $9.95 |
|
|
NWT,Latest style Men X-Loop sunglasses, Red frame,mirrored lenses,100% UVA & UVB $9.95 |
|
|
NWT, Latest, Mens X-Loop Sunglasses, Silver and Black frame, Black Lens, 100% UV $9.95 |
|
|
NWT, Latest HOT Mens X-Loop sunglasses, Gold and Silver color frame, Black lens $9.95 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses,Black / Silver frame with logo, Black lens $9.95 |
|
|
NWT,Latest style HOT Mens X-Loop sunglasses Black and Silver frame,mirrored Lens $9.95 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses, Silver and black frame, Black Lens,00% UV $9.95 |
|
|
Cotton Lace Cream Circle Loop Cowl Scarf Snood Latest! $15.67 |
|
|
Latest HD Car Key Chain DV Camera Camcorder Loop Recording Av-out #18 H.264 720P $36.00 |
|
|
NWT, Latest HOT Mens X-Loop sunglasses,Silver earpieces, Black lens,100% UVA&UVB $9.95 |
|
|
Latest Spy HD Key Chain Camera W/ Loop Recording AV-out 808HD#18 H.264 720P AVI $39.99 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses,Black and silver frame,Black Lens, 100% UV $9.95 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses,Bluw and Silver frame, Black lens, 100% UV $9.95 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses, Silver and Black frame,Black lens,100% UV $9.95 |
|
|
NWT, Latest HOT Mens X-Loop Sunglasses, Black over Blue Frame, Blue Mirror lens $9.95 |
|
|
NWT,Latest style HOT Mens X-Loop sunglasses Blue frame,Black lens,100% UVA & UVB $9.95 |
|
|
Vintage Tilco Latest Fashion Loop Bow on Comb Card with 5 1960′s $38.00 |
|
|
NWT,Latest HOT Mens X-Loop sunglasses Red over black Frame, mirror lens, 100% UV $9.95 |
|
|
NWT,Latest HOT Mens X-Loop Sunglasses,Black over Silver Frame,Black Lens,100% UV $9.95 |
|
|
NWT,Latest HOT Mens X-Loop Sunglasses, Red over Black Frame, Black Lense,100% UV $9.95 |
