|
-
Jan 31st, 2011, 10:43 AM
#1
Thread Starter
New Member
How do I read/write Excel cell data to textbox & visaversa
Hi,
I'm converting older VBA code to VB. I'm using Visual Studio or VB 2010 but am new to this "oop" approach and not a seasoned programmer.
Scenario:
1. Open new Excel worksheet (see below - will this work?)
Public Class frmMain
Prvate Sub frmMain_Load(ByVal sender As System.Object, ByVal e As -System.EventArgs) Handles MyBase.Load
Dim objExcel As New Excel.Application
objExcel.Visible = True
Object.Workbooks.Add()
2. Load text found in cell Range("A1") into form's Textbox1
3. Enable change/edit in Textbox1 to change A1 cell value
Can someone show me a basic example? Assume only one textbox and one cell for above scenario to keep it simple to begin.
Any quick help here would be much appreciated.
Thank you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|