Linking Cell Data to Data held in form

this should be pretty easy.

I made a VBA form to load information into, instead of an excel sheet.

Well, other sheets are linked to the old/original input sheet.

so when i had:

='Client Load - NOS'!R[-7]C[-2] &", " &'Client Load - NOS'!R[-7]C[4] &" " &'Client Load - NOS'!R[-7]C[7]

Which would actually input the City, State ZipCode

the form is named

frmJobTrack

and those 3 fields are:

txtCity
cmboState <---- is a drop down combobox
txtZip

Thanks!!!

Robert

Robert

Exactly what are you asking help to do? Post the data from the form to an output sheet? Load the form from a sheet?

rylo

the form has macros that pull client information from a database, and hold it as the "active" client that is being worked on.

So, I am trying to get the cells to pull information from the "active" client that is held in the VBA form.

I'd rather do that, than "push" the information from a Macro.

Hi

AFAIK, you can't get data to be pulled from a form by a spreadsheet. The form can take data from the spreadsheet, and push it back, but I don't think the ss can pull data from the form.


rylo

ok then.... it seems that it will have to be a "push" environment instead of a "pull."

i did a lot of formatting already and was trying to avoid writing code to re-format each cell... i still can't figure out the post i made in the programming about formating a form, and figured it'd be easier to write a formula.

Hi

Put up an example file that shows your data structure, your form, and any associated code. Advise what data to put in the form, and where you would like it to be output and I'm sure you will get help to resolve it all.

rylo