• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to edit the form of imported database in to excel

Ramesha

Ramesha

Member
I'm working on imported existing database! using the form button of excel, i get the form, but want to include drop down in one of the columns! how can I do it?
 
Deepak said:
A bit explain with sample workbook is required.
Click to expand...
Thanks again for your support! the file is the one which you updated for me today morning!

In that file under production data sheet - under column "L" would want to include the drop down, the drop down options are listed in column "S".

Thank you in advance
 
Sample file is the one that you uploaded for me today morning, want to include drop down in column "L" the drop down contents are in cells "S2 to S4"
 
Forgot to mention, I'm using the default Form command of excel, do not know how to get into the form generated by excel and include the drop down in that
 
This nothing to do with Forms.
You're looking fro Data Validation
Select Cell L2
Go to the Data tab, Data Tools section, choose Data Validation, then Data Validation…, in the Allow field choose List, then click in the Source field and then select S2:S4 on the sheet. =TextBox1 will show up there because you've named that range. It's good. Keep it. Click on OK.

To do the same for the rest of the column, you can copy down.
 
Thanks for your time! I'm familiar with data validation but I'm struggling while using the the form ribbon command, where the standard form is thrown up by excel(based on the ready table), do not how to access the code thrown up by excel, here would like to introduce dropdown
 
Ramesha said:
I'm struggling while using the the form ribbon command,
Click to expand...
I don't know what this is; could you supply a screenshot or otherwise describe what you're referring to?
Ramesha said:
where the standard form is thrown up by excel(based on the ready table),
Click to expand...
Again, I don't know how or where Excel 'throws up' this form.
Ramesha said:
do not how to access the code thrown up by excel, here would like to introduce dropdown
Click to expand...
Again, I don't know what or where this code is thrown up. More info needed.

I can easily put a combobox into a standard userform and have it show up a list of choices. Little or no coding required.
You have blank userforms in your file and some code behind userform1 but no controls on the userform that the code could relate to.
I am not going to write code and design userforms for you - that is significant work - especially as we don't know what you want it to do. I will however help you do so, but there has to be more than you presented in your file.

John Walkenbach has produced several books on vba programming in Excel including several (for different version of Excel) called Excel 20nn Power Programming with VBA. Here's one: https://wordery.com/excel-2010-powe...VnM2t0N1E9PQ&gclid=CPDt88WI6MYCFWXJtAodzLEPSQ
These are quite readable and one is able to follow the book since it has examples.
 
I'm enclosing the snap shot below, at the background is the data table, I use form command in the tool bar, then the form shown below popsup(generated by excel), in cell market would like to insert a drop down, since the code is generated by excel(automatically with form command), do not know where the code would be and how to edit it to include the drop down

upload_2015-7-20_15-14-6.png
 
Thanks for showing me where you got this form!
I remember playing wth this years ago - and at the time decided it was too dangerous to use safely. On revisiting it now, my opinion hasn't changed; it is too easy to make mistakes and on my machine at least, trying to edit dates can be confusing since it displays the dates in its own sweet way, regardless of how you want to see dates.
You won't be able to add a dropdown field in this data form, and although you can create code to bring up this dataform, because it's a modal form (all code stops while the form is showing), you won't be able to write any code at all to cope with changes you might make to the data on the form.
Don't use it!
It should be removed from Excel altogether and confined to distant memory (in my case it had been completely erased from my recall).
But that's only my opinion.
 
You must log in or register to reply here.
Back
Top