The following code does what I want...mostly. It prints zeros(in the sheet1 form that prints) in the cells the user doesn't place any input. How do I place drop down choices into a cell? Thanks
Please Login or Register to view this content.
The following code does what I want...mostly. It prints zeros(in the sheet1 form that prints) in the cells the user doesn't place any input. How do I place drop down choices into a cell? Thanks
Please Login or Register to view this content.
With Data Validation is one way...
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
I may not have posted correctly. The code was what I have so far. New at this forum and VBA. Data Validation? How?
This link will explain the basics of Data Validation
http://www.contextures.com/xlDataVal01.html
Hi Ray
Obviously I misinterpreted your question...please explain what it is you wish to do. I'll try again.
Thanks for the walk through, I'm liken' this forum thing.
Two sheets in the workbook. One(Sheet 2) has columns A:O, users input. At the last column a row is inserted(active cell returns to column A), input process starts over. The input ties into a form(Sheet 1) that prints at the press of a 'button'.
I'm trying to have blank cells in Sheet 1 input area. It shows zeros now. Would like to place 'drop down' box with various selections in some of the cells. Also place date format in a couple of cells also.
Hi Ray
How does Sheet1 get populated with User Input from Sheet2...by Formula? ... by Change Event Code?
What Cells in Sheet1 do you wish to have Dropdowns, what will be the Source of the Dropdown choices (this is where Data Validation comes into play).
What Cells in Sheet1 do you wish to have date format?
Need more info...a copy of your Workbook (sanitized) would be helpful
thanks for reply, have to logoff for now. will get answers this evening.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks