Posted to microsoft.public.excel.programming
|
|
Information about excel vs db tools
to retrieve date
Userform1.Textbox1.Text
should have been
to retrieve date
Userform1.Textbox1.Text = Range("A1").Value
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
Existing code to write data
range("A1").Value = Userform1.Textbox1.Text
Now add additional functionality
to retrieve date
Userform1.Textbox1.Text
after it is edited
range("A1").Value = Userform1.Textbox1.Text
obviously, there is more involved, but with no details, this should give
you the idea.
--
Regards,
Tom Ogilvy
wrote in message
ups.com...
Ok. mmm, haven't done that. Any quick tutorials?
Tom Ogilvy wrote:
If you used a userform to allow the user to enter data, then pulling up
existing data, allowing the user to edit it and writing it back should
be
trivial.
If you formatted a worksheet for this purpose, again, adding code for
the
additional functionality should be very easy.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
Hello,
I have an application that I wrote in excel. It has 80 fields that I
wrote a front end just to put data into the excel spread sheet. Now,
the customer would like to view and change records thru the front end.
I am not sure to go about this using excel. But I believe that using a
db tool like MSaccess would allow the functionality that the customer
requires. But the customer is unwilling to invest in the project -
there in lies the rub.
Is there a tool out there that is freeware that will allow me to
import
what I have built (GUI front and/or data from the excel sheet.) But
will allow for the reports (like access) based on the tables?
Or is there a way to write the change and review functionality in
excel?
Any advice would be appreciated.
|