Re: help pls.........
- From: "NickHK" <TungCheWah@xxxxxxxxxxx>
- Date: Fri, 2 Mar 2007 11:42:32 +0800
If the forms are in the WB, then there's no need for any ODBC etc stuff.
You can reference the WS directly.
'<Form1>
TextBox1.Text=Workshets(1).Range("A1").Value
'<Form2>
TextBox1.Text=Workshets(2).Range("A1").Value
How you display the WS data on the form is up to you.
Start simple to get something working, then add details.
NickHK
"Chinx21" <chinx21@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:69C6F68A-18C1-4CC0-BD64-50599CBBBED1@xxxxxxxxxxxxxxxx
Good day to everyone!to
nway,I'm going to detailed my current situation right
now and what I want to do.
I have a workbook named WBOOK with I think 20 worksheets. What I want is
have a User form(my main menu) to run whenever I open the workbook (I'vefound
already done that) I've also added forms (for every worksheet there is a
corresponding form).
What I want to do is to be able to edit and delete data from worksheets
through its form. Example: in student table which has a field of id no.,
name, etc. When a user want to edit he must provide an id no. then if
those information will be displayed in its corresponding control in theform.
how's that?somebody
I think my problem is in setting-up ODBC connection. When I click Tools it
has no "Reference" Sub Menu. By the way I'm, using Excel 2002. Could
help me how to set-up a connection less DSN" Like go to Control Panel then
find ODBC then what's next?
I hope you can help me.
Thank You for spending time with this. God Bless!
.
- Prev by Date: Re: Manipulating data from a portal (web)
- Next by Date: Re: Copying Graphs
- Previous by thread: Re: Manipulating data from a portal (web)
- Next by thread: Re: help pls.........
- Index(es):
Relevant Pages
|
