On Monday, September 28, 2015 at 9:21:48 AM UTC-7, GS wrote:
Claus and I outnumber you about using a userform with labeled input
fields. This will be easier for the user as well as less prone to
error if commas are not in the right places! You can input directly
from each field via event code -OR- validate each field's data via
a button click when done.
Much easier to manage data without any ambiguity, with or without
using an array to write to the sheet. If using an array you can
store the field's index in its 'Tag' property and myArr(CLng(.Tag))
to load its value.
--
Garry
I guess I need to bone up on userforms, not very versed on them at
present.
Thanks.
Howars
I'll see if I can muster up a sample using your fields...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion