Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2015, 08:00 PM
gwro005 gwro005 is offline Clearing Drop down list to default Windows 7 64bit Clearing Drop down list to default Office 2013
Novice
Clearing Drop down list to default
 
Join Date: Jul 2015
Posts: 3
gwro005 is on a distinguished road
Unhappy Clearing Drop down list to default


I am working with a form that includes approx 10 - 12 drop down lists that have answers from yes, no and N/A. This form will also include a section where comments can be entered. I am trying to find a way to use a macro to clear the form. (drop down list and comments). Any suggestions
Reply With Quote
  #2  
Old 07-22-2015, 10:47 AM
charlesdh charlesdh is offline Clearing Drop down list to default Windows 7 32bit Clearing Drop down list to default Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,

Can you provide a copy of the file so we can see what you are working with?
Reply With Quote
  #3  
Old 07-23-2015, 07:32 PM
gwro005 gwro005 is offline Clearing Drop down list to default Windows 7 64bit Clearing Drop down list to default Office 2013
Novice
Clearing Drop down list to default
 
Join Date: Jul 2015
Posts: 3
gwro005 is on a distinguished road
Default

At this time I can't. The file is a basic file with approx 14 sections that require a answer of yes, no or N/A. Those options are in a drop down box.
Reply With Quote
  #4  
Old 07-24-2015, 06:37 PM
macropod's Avatar
macropod macropod is offline Clearing Drop down list to default Windows 7 64bit Clearing Drop down list to default Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What kind of dropdowns are you using and what is your existing code?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 08-03-2015, 08:11 PM
gwro005 gwro005 is offline Clearing Drop down list to default Windows 7 64bit Clearing Drop down list to default Office 2013
Novice
Clearing Drop down list to default
 
Join Date: Jul 2015
Posts: 3
gwro005 is on a distinguished road
Default

Its your basic drop down with the responses of "Yes, No, and No". There is no other code in the form. I have attached a screen shot, regarding the drop down.
Attached Images
File Type: jpg form drop down.jpg (21.5 KB, 12 views)
Reply With Quote
  #6  
Old 08-03-2015, 08:26 PM
macropod's Avatar
macropod macropod is offline Clearing Drop down list to default Windows 7 64bit Clearing Drop down list to default Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by gwro005 View Post
Its your basic drop down with the responses of "Yes, No, and No". There is no other code in the form. I have attached a screen shot, regarding the drop down.
Aside from userform listboxes & comboboxes, both of which might be called dropdowns, Excel workbooks support dropdown controls, combo-box controls, ActiveX listboxes & ActiveX comboboxes. Hence, simply saying "Its your basic drop down" doesn't answer the question as to what kind of dropdowns are you using.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clearing Drop down list to default How to import list from Excel into drop-down list into word ahw Word VBA 43 02-28-2020 08:11 PM
Clearing Drop down list to default Drop Down List Help ksigcajun Word 3 05-09-2014 05:35 AM
Drop down list, Can it be done??? garethreid Outlook 0 08-09-2012 06:08 AM
Trouble with drop down list yessmarie Word VBA 1 05-25-2012 12:43 PM
Clearing Drop down list to default Drop Down List Question beb1227 Excel 6 12-08-2011 07:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft