Macro to select cell and open import dialog box

[judgesuds]

Hello there excuse my excel noobness


I want to run a macro that looks at a cell on a sheet within the workbook and if it is empty it opens the import file dialog box ( for which i am using SendKeys ("%ddd") *with the aforementioned cell selected*, else displays a dialog box saying the cell has a value in it.

I’m looking at something like this:

Sub Useless_macro()
Sheets("Sheet1").Select
Range("A1").Select
If ActiveCell = "" Then
SendKeys ("%ddd")
Else
MsgBox "There is a value in this cell"
End If
End Sub

[judgesuds]

ie i want to look at cell A1 on Sheet1 and if it is empty open the import dialog box with that cell selected...

[Palmetto]

There is plenty of help forthcoming, but first . . .

Per the Forum rules you agreed to follow, please amend your post and add code tags to all VBA code. Highlight all of the code, then click the # button.

Thanks.