How To call Worksheet_Change event from a different module

[Nerisha]

Hi.

I want to be able to call the worksheet_Change function from a different module on my excel workbook. I have code working properly when I call it from the actual sheet, but this sheet gets created via code, so I need the "Worksheet_change" event code to be added automatically as well. Can anyone help me?

 

[Nerisha]

For this, I need to remove the ToSql function, as it exists in a different module that wont be available when the worksheet_change event is fired. This is the reason for trying to remove it.

I basically need "Item" to have quotations when the query is executed.

 

[VoG]

You can add quotations using the DQUOTE variable as here http://www.mrexcel.com/forum/showpost.php?p=2527025&postcount=4

 

[Nerisha]

I am trying, with no results to get this query displayed:
sql = "SELECT AmountExcl, ItemDescr FROM Items WHERE ItemDescr = '" & Item & "'"

I'm so close to getting this right, if only I knew how to write the line of code, to that when I open the Worksheet_Change event, it looks like the above.

 

[Nerisha]

Ok, I got that working now. One other thing. The code works great, but when I run it, it opens up in the VBA editor, and not the sheet itself. How to I set the focus such that after the code is run, the focus is on the sheet.

 

[Nerisha]

Hi there, with regards to your code to "Insert Lines", this works great, but after it executes, it stays in the VBA editor. How can I get it to return to the datasheet view?