How can I reference a cell in add-in

danial

Board Regular
Joined
Apr 29, 2006
Messages
107
I want to create vba code to reference cell "A1" in the excel add-in.
I know I can type the direct reference. Workbooks("MyAddIn.xls").Sheets("Sheet1").Range("A1")

but when I changed the name of add-in file. that code is not work.
I don't want to change the code as the name of file
I try to put this code in Open Workbook
================================
Public Wk as Workbook

Sub Auto_Open()
Set Wk = Application.ActiveWorkbook
End Sub

Sub GetA1()
Msgbox Wk.Sheets("Sheet1").Range("A1")
End Sub
================================
This code can run on normal excel but when I save as the excel add-in
After that I try to run GetA1. It dose not work.

Does anyone please correct me
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Hi, :)

I want to create vba code to reference cell "A1" in the excel add-in.


If you liked to address a cell in the Addin, you must "ThisWorkbook" use:


Code:
MsgBox ThisWorkbook.Worksheets("Sheet1").Range("A1")
Case_Germany
 
Upvote 0

Forum statistics

Threads
1,213,562
Messages
6,114,326
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top