Are there and macro or VB wizards here?

I am making a form in VBA and really need help.

The form might be filled in a number of times  day and used to fill in a spreadsheet. Not all the fields will need to be filled in each time so I need the data to go in to specific cells rather than just the next empty one, otherwise the sequence of data might get scrambled.

Message 1 of 5
Latest reply
4 REPLIES 4

Are there and macro or VB wizards here?

Hi Pimpy--carry on with your quest.

Noticed the VB wizards in the OP.

Im one -can fill a fridge with VB..and work it over in a few days.

Worse in the summer.

Hope you get the real info you are looking for...........................Richo.

Message 2 of 5
Latest reply

Are there and macro or VB wizards here?

I came in for the VB. False advertising. 

Message 3 of 5
Latest reply

Are there and macro or VB wizards here?

http://www.techrepublic.com/article/pro-tip-add-a-userform-to-aid-data-entry-in-excel/

 

Pimpy, this looks like what you need.


-------------------------------------------------------------------------------------------------------------------------------

Buttercup: You mock my pain! Man in Black: Life is pain, Highness. Anyone who says differently is selling something.
Message 4 of 5
Latest reply

Are there and macro or VB wizards here?

thanks Amber, it almost is.  I'll keep searching but my attention span is dwindling. It's Richo's fault, now I want a beer.

Message 5 of 5
Latest reply