troubleshooting Question

excel database

Avatar of JCWEBHOST
JCWEBHOST asked on
Microsoft OfficeVisual Basic ClassicMicrosoft Excel
2 Comments1 Solution398 ViewsLast Modified:
hey guys i want to know if this is possirable with excel?

i want the user to insert information into the cell and coloums of excel document and insert into a database, the problem come when populating a coloum with like a dropdown selection where the user can insert any number of rows has long has it is in the right coloum.


i have found out how to use vba in excel and know how to insert i line and cells into a database, my problem is unknow rows and how to fomat a cell like a dropdown from a database.

or yes and is it possirable that each time a move to the next row that a new line to insert a record.

i know it is hard to do but its my client request.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros