Discussion Locked

Data Entry/Display Excel Spreadsheet

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

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.

This discussion is closed to new replies.