Hello ,

using the excel user interface, the following formula can be applied to a column.

– Userdefined

– formula: =IstZahl(A10)

This works properly.

I try to apply the same with VBA.

Dim formel as string

formel = “=IstZahl(A10)”

With column.Validation
.Delete
.Add Type:=xlValidateCustom, Operator:=xlEqual, Formula1:=formel, AlertStyle:=xlValidAlertStop
.IgnoreBlank = True
.InCellDropdown = False
.ErrorTitle = “Wert eingeben”
.InputMessage = “”
.ErrorMessage = “Der Wert darf keine Duplikate haben und muss eine Zahl sein.”
.ShowInput = False
.ShowError = True
End With

I get allways an error when the red line is executed.

I guess that the syntax is not correct but I find no error.

Manfred

​Hello ,using the excel user interface, the following formula can be applied to a column.- Userdefined- formula: =IstZahl(A10)This works properly.I try to apply the same with VBA.Dim formel as stringformel = “=IstZahl(A10)”With column.Validation.Delete.Add Type:=xlValidateCustom, Operator:=xlEqual, Formula1:=formel, AlertStyle:=xlValidAlertStop.IgnoreBlank = True.InCellDropdown = False.ErrorTitle = “Wert eingeben”.InputMessage = “”.ErrorMessage = “Der Wert darf keine Duplikate haben und muss eine Zahl sein.”.ShowInput = False.ShowError = TrueEnd WithI get allways an error when the red line is executed.I guess that the syntax is not correct but I find no error.Manfred  Read More

​

Windows Biomatric service disabe the fingerprint driver again & again , I tried to resart, reinstall but all in vain, in the end, fingerprint + windows hello face service is unavailable isn’t working,

​ Windows Biomatric service disabe the fingerprint driver again & again , I tried to resart, reinstall but all in vain, in the end, fingerprint + windows hello face service is unavailable isn’t working,  Read More

​

i don’t understand how i don’t have the requirements for this my PC is maxed on what it has.

thank you

​i don’t understand how i don’t have the requirements for this my PC is maxed on what it has. thank you     Read More

​

Hello,

I would like to roll out Windows Hello for Business (cloud trust). The configuration with Endpoint Manager is complete. Everything works very well for new installations.

There are problems with clients with activated Windows Hello (without Business). The only option here is to delete the Windows Hello configuration and then log on to the client with TPA. Windows Hello for Business can then be configured. Is there a better way to configure it for existings cliens with active windows hello (without Business)? 

If the user first login with password the PIN create runs in a timeout with the information it needs mor secure informaton,

Thanks for your help

Stefan

​Hello, I would like to roll out Windows Hello for Business (cloud trust). The configuration with Endpoint Manager is complete. Everything works very well for new installations.There are problems with clients with activated Windows Hello (without Business). The only option here is to delete the Windows Hello configuration and then log on to the client with TPA. Windows Hello for Business can then be configured. Is there a better way to configure it for existings cliens with active windows hello (without Business)?  If the user first login with password the PIN create runs in a timeout with the information it needs mor secure informaton,  Thanks for your helpStefan  Read More

​

I have a spreadsheet of values that is sorted by a column that has a formula in it, where the values of that formula come from market inputs etc.   Id like my list to sort itself automatically when one of the inputs is changed, rather than manually having to highlight and do the sort instruction each time, is this possible?

Thankyou.

​I have a spreadsheet of values that is sorted by a column that has a formula in it, where the values of that formula come from market inputs etc.   Id like my list to sort itself automatically when one of the inputs is changed, rather than manually having to highlight and do the sort instruction each time, is this possible? Thankyou.  Read More

​

Hello,

I woul like to make sharepoint list as our orders from customer database.

When we receive an order it usually concerns several products. 

How I can add several items/products + their quantity?

Please see an example of an order

Order no.DateCompanyNameProductsQuantityStatus12345619.10.2024MicrosoftJohn SmithA2     B3     C5 

​Hello, I woul like to make sharepoint list as our orders from customer database.When we receive an order it usually concerns several products. How I can add several items/products + their quantity?Please see an example of an orderOrder no.DateCompanyNameProductsQuantityStatus12345619.10.2024MicrosoftJohn SmithA2     B3     C5    Read More

​

When I try to update from version 27695 to a new version, I get a blue screen after logging in.

KMODE_EXCEPTION_NOT_HANDLED

I have uploaded the minidumps and the logs here.

https://drive.google.com/drive/folders/1uyL37s07UYLXvSqpxWOLmDfe2ISNXuYa?usp=sharing

​When I try to update from version 27695 to a new version, I get a blue screen after logging in. KMODE_EXCEPTION_NOT_HANDLED I have uploaded the minidumps and the logs here. https://drive.google.com/drive/folders/1uyL37s07UYLXvSqpxWOLmDfe2ISNXuYa?usp=sharing   Read More

​

tenho uma tabela de 1 coluna com 500 linhas, gostaria de imprimir com a coluna dando sequencia e quebrando na mesma folha, sendo 4 colunas em uma folha só sem precisar recortar e colar, é possível?

​tenho uma tabela de 1 coluna com 500 linhas, gostaria de imprimir com a coluna dando sequencia e quebrando na mesma folha, sendo 4 colunas em uma folha só sem precisar recortar e colar, é possível?  Read More

​

I hope this message finds you well.   When selecting a date, the system should display the available products in our inventory for that specific day. The order quantities will be entered manually, The system will then calculate the maximum value based on the order price tracker and determine the total costs by multiplying the order quantity with the unit costs.

Your assistance in this matter is greatly appreciated. Thank you for your cooperation and support.

Best regards,

Jeng Chi Order Guide 2024 – Copy.xlsm

​ I hope this message finds you well.   When selecting a date, the system should display the available products in our inventory for that specific day. The order quantities will be entered manually, The system will then calculate the maximum value based on the order price tracker and determine the total costs by multiplying the order quantity with the unit costs.Your assistance in this matter is greatly appreciated. Thank you for your cooperation and support.Best regards,Jeng Chi Order Guide 2024 – Copy.xlsm      Read More

​

I’m so disgusted with you Microsoft. After 20 years of learning how to use Excel moderately well you now force me out of Excel 2003 which you have bastardised so much it’s now impossible to use! You’ve changed it so much it’s useless to me! The lack of respect shown for your clients/customers who put in the time to learn how to use it now find ourselves with an unworkable system. This is an absolute disregard and waste of our time. I have wasted this weekend and been so turned off attempting to achieve what I had completed in 2003 Excel which I stayed with due to the decision YOU MADE to ‘choke’ Excel in accessing and using RAM – without telling us – which decided me to stay with 2003 for 20 years!! Good old faithful! But now your updates have crashed it so that I can no longer use it. I have had to change to 365 which is now the most screwed up convoluted and ridiculous program by comparison that it is a waste of time to have to re-learn a program which I could already use effectively. You might think 365 is a jewel but everyone I know who uses it think it’s junk and hates it with a vengeance. Most would happily go back but instead we’ll probably just complain and head for Linux instead. They care to have happy users! You don’t even answer so I’m even unsure as to why I waste my time except that I am so angry I need to vent my disagreement. My projects are now stymied after 20 years work thanks to your stupidity, ignorance and lack of thought for your world-based users! And your charts, what used to work may as well be written in a foreign language…and WHY! I wish I could let loose and tell what I really think, but I’d have to drop my standards so far that even I would be disgusted by it! Not happy Microsoft! I’D HAPPILY PAY YOU TO STAY AWAY FROM ME AND LEAVE ME WITH MY OLD PROGRAM! 

​I’m so disgusted with you Microsoft. After 20 years of learning how to use Excel moderately well you now force me out of Excel 2003 which you have bastardised so much it’s now impossible to use! You’ve changed it so much it’s useless to me! The lack of respect shown for your clients/customers who put in the time to learn how to use it now find ourselves with an unworkable system. This is an absolute disregard and waste of our time. I have wasted this weekend and been so turned off attempting to achieve what I had completed in 2003 Excel which I stayed with due to the decision YOU MADE to ‘choke’ Excel in accessing and using RAM – without telling us – which decided me to stay with 2003 for 20 years!! Good old faithful! But now your updates have crashed it so that I can no longer use it. I have had to change to 365 which is now the most screwed up convoluted and ridiculous program by comparison that it is a waste of time to have to re-learn a program which I could already use effectively. You might think 365 is a jewel but everyone I know who uses it think it’s junk and hates it with a vengeance. Most would happily go back but instead we’ll probably just complain and head for Linux instead. They care to have happy users! You don’t even answer so I’m even unsure as to why I waste my time except that I am so angry I need to vent my disagreement. My projects are now stymied after 20 years work thanks to your stupidity, ignorance and lack of thought for your world-based users! And your charts, what used to work may as well be written in a foreign language…and WHY! I wish I could let loose and tell what I really think, but I’d have to drop my standards so far that even I would be disgusted by it! Not happy Microsoft! I’D HAPPILY PAY YOU TO STAY AWAY FROM ME AND LEAVE ME WITH MY OLD PROGRAM!   Read More

​