VBA: Using two values to create an intersection

CarliniBO · 30. Juli 2024

Hello everyone, I have two separate tables, one contains location information and the current quarter in a fixed position. Location 1Q1I would like to run a macro, which takes the above mentioned information and marks the intersecting cell in color in a different worksheet. LocationQ1Q2Q3Q4Location 1GreenLocation 2Location 3Location 4 Many thanks

ClausReich

Hello Franziska! I am Claus, an Independent Consultant from the Microsoft Community! Glad to be able to help you!

If you writing an e-mail using Outlook, and trying to create a table with the text written totally close to the left, you can simply create the table on the email directly, start typing, and the text should be formatted as left as possible. You can use the two buttons I've circled on the attached screenshot to move the text around.

JoseBeltre

Thanks for your feedback. In that case, I suggest you to create a ticket using the Microsoft 365 admin console.

CharlesKenyon IA

Note, your code puts your textbox, not in-line-with text, in the top right corner of your document. If that is where you want it, the building block can create it there.

You still have not explained why you want to do this with a macro.

I know of no way to, using vba, directly insert a content control mapped to that node. someone else may. The only way I can do it is using a Building Block.

Q550

https://social.technet.microsoft.co...-their-intersection-points?forum=visiogeneral

Pauline R.

Hallo Häns,

du könntest alle Termine per Hand in deinen Hauptkalender kopieren (über die Listenansicht). Wenn du das Kopieren per VBA machen möchtest, schau ob dir diese Seiten weiterhelfen:

http://www.slipstick.com/developer/copy-new-appointments-to-another-calendar-using-vba/

http://www.slipstick.com/developer/save-appointments-to-a-non-default-calendar-folder/

Gruß,

Pauline

Hi,

willkommen im Windows Forum!

VBA: Using two values to create an intersection - Similar Threads - VBA Using two	Forum	Datum
How to add signature with images using VBA How to add signature with images using VBA: I am using below VBA code source to add a signature with images to a new mail item. The code works perfect for external and internal mails.Now I wanted to add this functionality to automatically...	Outlook.com	8. Oktober 2024
how to create an account? how to create an account?: I tried to create an account at least 10 times and always get this message:"Account creation has been blockedWe have detected some unusual activity and have blocked the creation of a Microsoft...	Outlook.com	30. September 2024
how to create an account? how to create an account?: I tried to create an account at least 10 times and always get this message:"Account creation has been blockedWe have detected some unusual activity and have blocked the creation of a Microsoft...	Microsoft Office	29. September 2024
How to find values with multiple criteria, then display values in Dropdown How to find values with multiple criteria, then display values in Dropdown: Dear ladies and Gentlemen, I have a question concerning a function in Excel:The goal is to have a drop-down window of values. The values are chosen based on 3–5 criteria. In each line, new...	Microsoft Office	20. Juni 2023
Word: Create appendix with automatic numerotation using "numbering" Word: Create appendix with automatic numerotation using "numbering": Dear community,I successfully create numerated appendix using numbering and creating a list as shown bellow:but I have an issue with the formatting of the style. I do not know how to remove the...	Microsoft Office	16. April 2022
Create dynamic formula with value from dropdown list Create dynamic formula with value from dropdown list: Hi guys, I have an excel sheet that I am using to calculate markups and margins of a fashion production. There are two tabs: 1 Calculating retail prices and their margin after discounts 2...	Microsoft Office	10. Januar 2021
office 2010, using excel vba, word vba, powerpoint vba office 2010, using excel vba, word vba, powerpoint vba: Hallo, ich habe das Problem, das sich auf einem neuen HP Laptop Office 2010 nur einschränkt nutzen läßt. Für die Komponenten EXCEL, POWERPOINT und WORD ist es nicht möglich VBA anzusprechen. Ich...	Microsoft Office	4. Februar 2019

VBA: Using two values to create an intersection

VBA: Using two values to create an intersection

Text in table not displayed at the right place / What is this grey area in the ruler and how to change it?

Customize message when user requests password reset

Word 365: Einfügen eines Schnellbausteins in ein Textfeld

Linien an Schnittpunkten trimmen?

Mehrere Kalender im angehefteten pop up anzeigen lassen

User Advert

VBA: Using two values to create an intersection - Microsoft Office

VBA: Using two values to create an intersection - Similar Threads - VBA Using two

How to add signature with images using VBA

how to create an account?

how to create an account?

How to find values with multiple criteria, then display values in Dropdown

Word: Create appendix with automatic numerotation using "numbering"

Create dynamic formula with value from dropdown list

office 2010, using excel vba, word vba, powerpoint vba

VBA: Using two values to create an intersection solved