View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default small easy userform

i got a userform. with a cmdbuton on a sheet named "verify" column a down i
got 50 words. and column b i got 50 difrent combinations of 4 numbers. i need
the folowing code. 1 when i click the cmdbuton it needs to call the userform.
2 when it opens up in one block randomly go and pick a word from column a. 3
the user enter a 4 number combination. click the okay buton it verify that
the number combination is in fact the one next to the word picked from colmn
a. then run macro "editsheet"
phillip