Enter Button Function

**phoztek** · 09-28-2009, 07:11 AM

Hello all

I need some help developing a function that allows me to insert some info.
The info is inserted on a Sheet, and it as an Enter button, when its pressed he saves the info in another Sheet.

Dont know if this is possible, but all the help will be appreciated

Please find the attachment

**rwgrietveld** · 09-28-2009, 08:01 AM

Here is something you can play with.

There are other ways too.

**phoztek** · 09-28-2009, 08:19 AM

Thanks for such a fast reply.

Well this seems to be a good way of doing it, but since im a "noob" can you explain how can i edit these fields ?

Thanks +1 For u

**rwgrietveld** · 09-28-2009, 08:52 AM

Go to View->Toolbars->Control Toolbox

Toggle Design Mode / Exit Design Mode and you'll be able to use it.

**phoztek** · 09-29-2009, 07:28 AM

Any other suggestions ? I would appreciate it.

Thanks in advance for the replys

**phoztek** · 10-01-2009, 08:05 AM

Hi again,

Well i decided to stick with the model that rwgrietveld posted,

Just a thing or two, is it possible to protect those VB Cells, if those are lets say dates. That way i would allways have the same type.

EG:

Imagine one puts 10/10/2009 or 10-10-2009, and the outcome result would be 10 October 2009

I've tryed formating the main cells on having this but only the first date changes currectly.

Or even like 3 Fields with Day / Month / Year that would join up together and show up in the Destination Sheet like 10 October 2009

Don't know if anyone understood what i sayed.

PS: Sorry for my bad english