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

P

PackersXLVGirl

Hello:

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

I have a user form that requires our engineering team to submit to m
department when they are changing a process router. I have the userfor
set up, and the code written (incorrectly obviously). What I need it t
do is once the engineer enters the data and presses "OK" the form shoul
take the fields and fill out the corresponding Tracking form, with th
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 Trackin
Form spreadsheet.)

Any help that can be given would be greatly appreciated. And if I'v
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
+-------------------------------------------------------------------
 
C

Cimjet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top