Newport Count
Active Member
- Joined
- Oct 25, 2009
- Messages
- 328
Hi,
i have created a userform in excel that once opened allows users to fill in information that gets logged in a spreadsheet
the spreadsheet holds all data that gets sent from the form as well as another few fields that are created based on the values entered from the form
eg cell C2 in the spreadsheet uses the initial letter from one field sent from the useform and the last three numbers from another field sent from the userform
is it possible, once the user has sent an entry to the form, that a pop up box can display a different cell from the spreadsheet based on the last entries?
userform entry1: Cardiff
userform entry2: 123456
example pop up box: C456
hope that makes sense
Cheers!
i have created a userform in excel that once opened allows users to fill in information that gets logged in a spreadsheet
the spreadsheet holds all data that gets sent from the form as well as another few fields that are created based on the values entered from the form
eg cell C2 in the spreadsheet uses the initial letter from one field sent from the useform and the last three numbers from another field sent from the userform
is it possible, once the user has sent an entry to the form, that a pop up box can display a different cell from the spreadsheet based on the last entries?
userform entry1: Cardiff
userform entry2: 123456
example pop up box: C456
hope that makes sense
Cheers!