Retrieving multiple fields with SQL - the data do not show up

11 views
Skip to first unread message

Håkan Björkström

unread,
Nov 21, 2018, 9:16:25 AM11/21/18
to excel vba
Hello guys

I have a very simple SQL-retrieving routine reading four fields from a large Excel file and writing them to four cells in an excel sheet. The routine is triggered with Worksheet_Change() when I enter a number in column 1. The routine fetches the data and inserts them into the appropriate cells but only the first field is visible- the other three are not  although the data in the cells are there. Not until I edit (F2) one of the fields, all four will be visible.

How should I handle the recursive Worksheet_Change() when my SQL routine writes the retrieved data to the worksheet?

Håkan
Reply all
Reply to author
Forward
0 new messages