Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
 

Hello:

My name is Mich and I'm new to the group and I'm having an issue wth a userform that I created that needs to feed data to an Excel spreadsheet within the same woorkbook.

I have a user form that requires our engineering team to submit to my department when they are changing a process router. I have the userform set up, and the code written (incorrectly obviously). What I need it to do is once the engineer enters the data and presses "OK" the form should take the fields and fill out the corresponding Tracking form, with the data from the userform. For some reason, I cannot get it to work.

(Ex. CCTC # should then be filled out into the CCTC # on the Tracking Form spreadsheet.)

Any help that can be given would be greatly appreciated. And if I've explained what I need, poorly, please let me know.

BTW, I am VERY new to VBA!

Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...
 

Hi Mitch
To do what your asking is nothing short of a few hours of work.
But go see this link and download a sample file. It will show you how to do it.
http://www.fontstuff.com/ebooks/free/index.htm
In the Excel section Handout the last file.
It's called "fsUserforms.xls" Yes it's an older version of Excel 2003 but should
work on your version.
Cimjet
"PackersXLVGirl" wrote in message
...

Hello:

My name is Mich and I'm new to the group and I'm having an issue wth a
userform that I created that needs to feed data to an Excel spreadsheet
within the same woorkbook.

I have a user form that requires our engineering team to submit to my
department when they are changing a process router. I have the userform
set up, and the code written (incorrectly obviously). What I need it to
do is once the engineer enters the data and presses "OK" the form should
take the fields and fill out the corresponding Tracking form, with the
data from the userform. For some reason, I cannot get it to work.

(Ex. CCTC # should then be filled out into the CCTC # on the Tracking
Form spreadsheet.)

Any help that can be given would be greatly appreciated. And if I've
explained what I need, poorly, please let me know.

BTW, I am VERY new to VBA!


+-------------------------------------------------------------------+
|Filename: 120126124438-43063.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=279|
+-------------------------------------------------------------------+



--
PackersXLVGirl