Forum

Hi Dashu, To define relationships, you can use a simple excel table: Parent Child UserForm1 UserForm2 UserForm1 UserForm...

Hi Hitesh, RunningSum = SUMX(FILTER(ALLSELECTED('Date'[Date]),'Date'[Date]<=MAX('Date'[Date])),[Active Head Count]) A month Count is needed: ...

Hi Justin, Looks like you are using the automatic combiner, which is not a good idea. Keep in mind that the combiner is not as flexible as it sh...

Hi Zak, How would you highlight a missing value in a merged range? Please prepare an example to clarify this problem.

Hi Jack, If you cannot login manually, the answer is in the site, you have to contact them.

Instead of .Send, use .Display to see the email.

Here is an example that is using a RangeToHTML function, you can use it to pass the pivot range to email body.

Hi Jonathan, Before launching the form, you can populate any fields you want: FormName.FieldName1.Value=Cells(Rw,"A").Value FormName.FieldName2...

Hi Tina, The line that sends the email is disabled: '.Send Remove the apostrophy and will work

Hi Mourad, You will have to provide an excel file, with sample data that is required for those 4 arguments of the function you mentioned. The fu...

Hi Sam, Here is an example that is attaching to a new email a PDF and one of the sheets saved as a new workbook. It also has the code to add a r...

Most probably, the error says something like: "Cannot combine text and numbers" You have to make sure the data type is the same (text), basically this...

Hi Omar, Have you tried .SendUsingAccount?

Can you upload a sample file with your structure?

You should accomodate with object browser in vba, will save you lots of time. In the image you can see all the properties for a connection obje...