General discussion

Locked

Data Entry/Display Excel Spreadsheet

By hurdk ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data Entry/Display Excel Spreadsheet

by SanKulPune In reply to Data Entry/Display Excel ...

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.

Collapse -

Data Entry/Display Excel Spreadsheet

by hurdk In reply to Data Entry/Display Excel ...

The question was auto-closed by TechRepublic

Collapse -

Data Entry/Display Excel Spreadsheet

by carquiza In reply to Data Entry/Display Excel ...

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

Collapse -

Data Entry/Display Excel Spreadsheet

by hurdk In reply to Data Entry/Display Excel ...

The question was auto-closed by TechRepublic

Collapse -

Data Entry/Display Excel Spreadsheet

by hurdk In reply to Data Entry/Display Excel ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums