Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


barman09

38 posts

Geek


#63936 4-Jul-2010 11:02
Send private message

First up I will say sorry because this is probably in the wrong forum...I just didn't know where else to put it.
Now, onto my problem:

I have an excel book with 3 different sheets in it. At the top of each sheet is a form with an image as a background (I work for my Dad's company and this is something they have supplied me with) and I have inserted some text boxes over the top of the form so that I can fill out details (job name, job number, date etc).

What I want to be able to do is insert the required fields on the 1st sheet (e.g the date) run a macro and have it automatically appear in the text boxes on the other two sheets. But I have no idea how to do this.

I will supply any info needed if someone could please offer some help :)

Thanks in advance 

Create new topic
rvangelder
352 posts

Ultimate Geek


  #347766 4-Jul-2010 19:23
Send private message

The Development forum is where you want to be.

You can often get the code you want by hitting the macro recorder, performing the desired action, then examining the captured code.

It's difficult to tell what you really want.
Send me a PM and I'll provide my e-mail address.

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.