We help IT Professionals succeed at work.
Get Started

Visual Basic Express 2010 & Excel

485 Views
Last Modified: 2015-03-31
I think this will be easy to answer but I know nothing about code so hopefully someone can help out.
I have an Excel workbook with 2 sheets (Sheet1, Sheet2, Sheet3).
I need Visual Basic Express 2010 code for a button to copy data from form to specific cells in Excel workbook.
For Example:
Copy data from Form1, Textbox1 to Workbook "Invoices" Sheet1, Range A7.

This is a new project and will be progressing such as:
Adding Access database to Excel Via VBE in order to create drop down menu(s)
Making the program secured by username and password for 30 days
Only able to view and print in pdf, hiding all spreadsheets and documents from Excel and Word
etc - but that more headaches to come, for now I just need to build the excel spreadsheet properly

Thanks
Comment
Watch Question
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE