Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Conditional formating of text box in Excel
My workbook consists of a sheet containing data on office occupancy and a series of sheets for each area where text boxes are overlaid on top of an image showing a floor plan. The text boxes are linked to concatenated values from the first sheet to display "visually" who sits where, along with...- Chris68a
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Conditional formating of text box in Excel
I am looking for a way to automatically apply formatting on text boxes depending on the value in a cell (basically having the same effect on the text box as "conditional formatting" can do to cells). Thanks!- Chris68a
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Open excel after Transfering Data
If you want to open a specific sheet in a workbook, you can also use: Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True xlApp.workbooks.Open ("path to file\file.xls") xlApp.sheets("SheetName").Activate Dim oApp As Object- Chris68a
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
