News

Learn the basics of using buttons and text boxes on Microsoft Excel worksheets. Also create Excel projects using Office development tools in Visual Studio. This walkthrough shows the basics of using ...
This VBA-Routine for Excel helps you to analyse text string and assigne them to categories. It is an easy to use tool! Many questionaires use closed questions. But there are often also open-end ...
What is InputBox? VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.
For instance, in VBA you can write code such as "a="Hello World"" and Excel knows that the "a" variable refers to text. However, in VB or .NET applications your default properties must specify the ...
Problem: Ich möchte in Excel ein numerisches Ergebnis mit einem Text verbinden. Dies geht, indem man «="Das Ergebnis lautet "&A1» eingibt. Leider kann ich diese Zahl nicht formatieren.