Excellent. Many thanks Harley - this had me stumped for days. It works perfectly.
I have learnt lots from you guys on this little exercise.
My regards,
Joe
Thanks for your assistance, Harley, it is very much appreciated. The code below almost works.
Can you please tell me why it will not work after the spreadsheet is shut down and restarted? It retains the selected item of the run done before the shutdown, but has nothing else in the drop down...
Thanks for this information, John.
I really just want to fill the drop down menu using the AddItem method, but it still does not work for me, even using your suggested code.
As I am new to VBA, can you please explain the meaning of your comment below, and how should I get around it:
"Note...
I have a combo box I wish to fill with item names using only VBA ie., no copying an array from somewhere else. Is this possible?
I have tried the following without success:
Private Sub Forms.ComboBox1_Change()
With ComboBox1
.ListFillRange = ""
'.AddItem "A"...
Many thanks to all who posted, especially Greg Palmer who had the right idea.
I made a BartPE pre-environment CD - very simple to do. I added a KeyViewerPE whcih Bart supplied. It is a modified keyviewer program, which lets you look in any WINDOWS directory in any partition.
On the laptop that...
I am in the process of repairing a laptop with WinXP and AOL7.0.
I need to backup files, as the registry is corrupt, and will not open Windows or the Disaster Recovery.
Can anyone please advise where I might find the AOL emails on this HDD, as the owner wants them saved and transferred back...
I have a laptop with a corrupt WinXP registry. It will not open Windows or Disaster Recovery. I need to recover the existing WinXP Product Key before I do a clean install.
Can anyone advise of a DOS program that will do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.