nirmalachr
New Member
- Joined
- Nov 25, 2013
- Messages
- 26
Hi,
I am creating a User form to save the difference departments discretion numbers, here i am facing a problem that in Combo box 10 i am having list of departments and combo box 11 is having departments sanctioning authorities now i have to generate the next discretion number based on the above values and it should not be duplicate and the same values will be saving in the excel sheet as below
combo box 10. value will be saved in "AH"
combobox11.value will be saved in "AI"
"AJ" value will be the discretion number generated.
Can any one help in this regard, Thanks in advance.
Manu
I am creating a User form to save the difference departments discretion numbers, here i am facing a problem that in Combo box 10 i am having list of departments and combo box 11 is having departments sanctioning authorities now i have to generate the next discretion number based on the above values and it should not be duplicate and the same values will be saving in the excel sheet as below
combo box 10. value will be saved in "AH"
combobox11.value will be saved in "AI"
"AJ" value will be the discretion number generated.
Can any one help in this regard, Thanks in advance.
Manu
