![]() ![]() If f.Value "" Then ComboBox7.AddItem f.Valueįor Each h In. If d.Value "" Then ComboBox2.AddItem d.Valueįor Each f In. ![]() If e.Value "" Then ComboBo圆.AddItem e.Valueįor Each d In. ![]() If c.Value "" Then ComboBox3.AddItem c.Valueįor Each e In. I'm not sure how I can do this because there is a loop and the books I have don't cover this.įor Each c In. SetEntry 'A sub that adds date and time on same row.Īfter each value is inserted to a cell, I need the text to be indent twice, make the cell row height larger, format the text a certain font and color, and other particular formatting. Set iRow = ActiveWorkbook.Worksheets("ReqLog").Cells(Rows.Count, 5).End(xlUp).Offset(1, 0) If Me.cboSubmittedBy.Value = "" Or Me.txtDateSubmitted.Value = "" Or Me.txtReqNo.Value = "" Or Me.Arow1.Value = "" Then ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |