Thread: Userform
View Single Post
  #2 (permalink)  
Old August 26th, 2011, 03:01 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

If it is a direct table you could have linked your textbox to the excel file using Controlsource property. Since you have multiple values for an entry, you need to manipulate this yourself with VBA code.

You can write the logic in the Change event of the textbox

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
Reply With Quote