Hi,
I have created a system where users can book pcs for people but i would like to add to my vba coding so when a booking is made, it is automatically set to Centre Across Selection for the text, i have tried " .HorizontalAlignment = xlCenterAcrossSelection" and it kind of worked in the sence that the text was centered but only accross the the first cell in the selection.
Any reasons or advice?
Many thanks,
Nick.
Syntax is:
How are you trying to do it?
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Ok, I will try this, does this go at the beggining or end? thanks
Hi, Nick,
make sure that there is only text in one of the cells (most favourable the most left handed one) otherwise the centering will only be done within each single cell.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Beginning or end of what?Originally Posted by Happy Booking
You've not shared either your workbook or your code, so I have no idea what you are already doing...!
ok heres my current code:
Sub Booking()
'Make red
Selection.Interior.ColorIndex = 33
'Make Bold
Selection.Font.Bold = True
End Sub
Its not much but it works, to this where would i add the following:
Range("A1:E1").HorizontalAlignment = xlCenterAcrossSelection
Many thanks,
Nick
What is your selection? A single cell, or a range of cells? Do you know? Does it matter?
Which range of cells do you want to center across? Whatever is selected? A fixed number of columns to the right? All the empty cells until the next value is reached?
What do you want to do if there is already content in those cells? Ignore it, delete it?
Your requirement is too vague to give you an answer.
I want a user to be able to drag accross from left to right (the number of cells will always vary) and then make that booking, this bit is fine but the next bit, after the booking has been made i want it so the user can double click anywhere in the booking and type a name that will be centered across the selection.
Thanks
Okay - to achieve your requirement of double clicking the range, and entering a label which is centered, you actually need to merge the cells, not just center across selection.
So try:
Please Login or Register to view this content.
Ok, That wont work in a shared workbook though will it?
No.
Do you know how frustrating it is to get information about your requirements drip fed, bit by bit?
I'm sorry, is there anyway of fitting my requirments while being able to share the workbook? or near enough hitting my requirments and being able to share?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks