View Single Post
 
Old 08-01-2016, 03:13 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,380
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

Your code is looking for a formfield called "Dropdown1". This doesn't exist in that document.
Your 4 bookmarks are called Dropdown, Dropdown2, Dropdown3, Dropdown4

The sub Index fails for two reasons. Replace returns a string not a Long. Also, removing the string "DropDown" from the string "DropDown" returns an empty string (not the number 1 you were probably expecting).
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote