1-10 of 53 Hubssort by Hot Best Latest
70
61Improve your workplace productivity with VBA
In today's competitive workplace enviornment employees are pressured to become both more accurate and efficient. Without the appropriate tools this can prove to be quite a challenge. In my experience in the workforce, I have found VBA to be a very...
0 comments
68What is Offset in VBA(Visual Basic)?
Offset is a code property in Visual Basic. Let's learn what is it and how to use it for your Visual Basic Macro development.
2 comments
71Porgramme to Solve the words in a set of jumbled Alphabets
I had created this program while playing text games on BING so that I can quickly solve puzzles and earn points... lost the lust after sometime. But searched a lot on Internet at that time and did not find it....
3 comments
83Enter Data in an Excel UserForm
To make it easier for users to enter data in a workbook, you can create a UserForm. It requires some programming, and the steps are clearly shown in the following short videos. In this example, inventory data is stored on a...
7 comments
81Silent Connection with SAPLOGON with RFC SDK Example | RFC | Excel | VBA
This tutorial demonstrates how to make a silent connection using VBA (or Visual Basic), either from an Excel worksheet or VB client. The tutorial uses the BAPI Control and SAP Logon Control, both of which, are included with the SAPGui and RFC SDK.
0 comments
73How to write a MS Excel Macro
Microsoft Excel is a very handy tool many of us use for our daily calculations. It can be used in simple calculations to advanced data processing. Anybody who wants to master excel, should know how to write...
3 comments
73MS Access Conditional Formatting
Public Function HighLightForeignKeys(argFieldName As String, _ ArgFieldValue As Integer) Dim FormatCondition As String Dim CodeReception As Integer CodeReception = ArgCodeReception 'FormatCondition =...
1 comment70MS Access Format Function
In Access, the Format function takes an expression and returns it as a formatted string. The syntax for the Format function is: Format ( expression, [ format ] ) expression is the value to format. ...
2 comments
69MIS Interview Tips for Excel/VBA/Access/SQL
You may already have seen it or may be still looking for it, here I tried creating a space where you can see consolidated view of excel and VBA questions generally asked in Interview. You may add your own...
0 comments
