Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1060
  • Last Modified:

access vba - textbox in worksheet

Hello

There is textbox3 on sheet1 of a workbook. I am in access and using accessvba. Now how in access VBA – I can do this >
Go to textbox3 of sheet1 of workbook and make it display “show”

?

Thank you
0
Rayne
Asked:
Rayne
1 Solution
 
Rey Obrero (Capricorn1)Commented:
test this codes

Sub postToXL()
     Dim xlObj As Object
     Set xlObj = CreateObject("Excel.Application")
          xlObj.workbooks.Open CurrentProject.Path & "\book1.xlsx"
          With xlObj
               .Worksheets("sheet1").textbox3.Select
               .Worksheets("sheet1").textbox3.Text = "Show"
               .Visible = True
          End With
          xlObj.Quit
End Sub
0
 
RayneAuthor Commented:
Thank you Rey
:)
Works great
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now