Data Entry/Display Excel Spreadsheet
I am interested in using a Visual Basic program to enter or display data in a specific row and column of an Excel spreadsheet. Entry would include overlaying
what is already there.
Web Development
I am interested in using a Visual Basic program to enter or display data in a specific row and column of an Excel spreadsheet. Entry would include overlaying
what is already there.
by sankulpune
Hello hurdk,
Assuming that you are entering the data in a textbox ('TextBox1') on a form and you want the value entered in the textbox to be placed in the cell A1 enter the following code in the AfterUpdate event of 'TextBox1'.
Range("A1")=TextBox1
I would be glad to provide any more specific help you may need in this regard.
SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.
by hurdk
by carquiza
Hi,
Here is another way:
TextBox1.Value = Sheets("Sheet1").Cells(1,1).Value
Hope this help.
Cheers,
Mel Arquiza
Home Page Design
http://hpd.welcome.to
by hurdk
by hurdk
This discussion is closed to new replies.
Sort by Trending