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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Enter Value and Format Cells Based on a Selected Range
Attached is what I've been working on so far, but concentrating on other aspects of it (I need it to do more than this particular bit). As I said, I'm very new to vba and learning as I go, so there isn't much yet. I appreciate the date is not a text value, I would need to convert that or ensure...- Yajeep
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Enter Value and Format Cells Based on a Selected Range
I'm very new to VBA. In Excel, I have a row with dates as headers and a column with names (effectively a calendar). I want to fill (colour) a range of cells against names selected from the list and enter text (preferably merging them first), but I want to select the range being filled based on...- Yajeep
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
