Hello...say I have an access database open and an excel book open...I need a macro in excel that will make a cell equal one of the textboxes in the access database form that I currently have open. The form changes based on what you click in access so basically I want a button in excel that will copy and paste that data from that textbox in access as what it is at that point in time. Let me know if this is possible.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel cell equals textbox in MS Access
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Similar threads
- Replies
- 6
- Views
- 242
- Replies
- 7
- Views
- 430
- Question
- Replies
- 0
- Views
- 446
