shrinivasshweta
New Member
- Joined
- Dec 29, 2016
- Messages
- 18
Code:
Label32.Caption = Replace(Replace("abcd-" & Replace(Left(Me.ComboBox1, 3), " ", "") & "-" & Replace(Left(Me.ComboBox2, 3), " ", "") & "-" & Replace(Left(Me.ComboBox3, 3), " ", "") & "-" & Format(TextBox1.Value, "00") & "-" & Replace(Left(Me.ComboBox4, 3), " ", "") & "-" & Format(TextBox2.Value, "00"), "--", "-00-"), "--", "-00-")
If Right(Label32.Caption, 1) = "-" Then Label32.Caption = Label32.Caption & "00"