this question is about DATABASE(ACCESS) AND VBA (EXCEL) DATA BASE There are 3 co

Question

this question is about DATABASE(ACCESS) AND VBA (EXCEL)

DATA BASE

There are 3 comboBOx

1st for Origin

2nd for Destination

3rd for (string) ex ) 325 Flight "origin" to "destination

at last, I need to make a text box "Depart time" for the flight i selected.

Please help me what vba code I need to use,

Thanks.

FltNumberOrigin 129 Roanoke 245 Roanoke 338 Charlotte 450 Charlotte 554 Roanoke 703 Roanoke Destination DepartTime. ArriveTime Click to Add Charlotte Charlotte Greensboro Atlanta Charlotte Greensboro 11:29:00AM 3:22:00 PM 10:42:00AM 1:23:00 PM 6:15:00 AM 8:05:00 AM 12:23:00 PM 4:29:00 PM 11:39:00 AM 2:51:00 PM 7:21:00 AM 8:55:00 AM

Explanation / Answer

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3
Private Sub UserForm_Initialize()
departTime.Controls.Add "Forms.TextBox.1", "departTime", True
departTime!Name1.Text = "departTime"
End Sub

End if

End Sub

explaination:--first it will trigger if any changes occur in worksheet...then we are checking condition for whether any changes done for particular column or not..if so creating new textbox named depart time.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.