Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Excel Data To VB Text Boxes

Status
Not open for further replies.
Shfog

Shfog

Programmer
Aug 24, 2001
20
US
I need to pull data from various cells into the text boxes of a VB App so that the data can be edited before sending it to a SQL Server Database.
The code I have found assumes that the data is neatly organized and then sends it to a list view in VB.
Can this be modified to select only certain cells (which are named) and send them to text boxes in VB?
Thank You....



 
Sort by date Sort by votes
The cells I need to pull from are "random", but are consistent in each template..(J10,H24,AL17,U32,etc each time) So the cells can be assigned in the program...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
533
strongm
strongm
Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
2K
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top