Good Morning Everyone.
i have this bit of code, and seems to only work when it feels like it and not all the time. its in a dropdown list box, its on sheet 1 and its not on a userform its on the worksheet itself. Any ideas please.
Private Sub worksheet_Activate() Dim i As Integer Dim location As String For i = 20 To 200 Sheet1.Bpm.AddItem i Next i End Sub
that code will run when you switch to the worksheet from a different sheet-you really ought to clear the list first or you will keep adding the same items to the list
Josie
if at first you don't succeed try doing it the way your wife told you to
OMG as simple as that lol, thank you it worked.
flyinghigher2011,
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
flyinghigher2011 
Register To Reply
Bookmarks