Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent Visual Basic Snippets

« Prev 1 2 3 4 Next »

Visual Basic formIsLoaded(String) As Boolean

This function returns True if the specified form is open in form view or datasheet view.

form

0 515 posted 13 years ago by CaptainProton

Visual Basic WSH (VBScript): Windows 7 New File Context Menu Item

A modification of Bill James' New Folder context menu script ( http://billsway.com/vbspage/ ), this script instead creates a "New File" item in the right click context menu of Directory Backgrounds. Upon running the New File item, you will be prompte...

file
windows

0 829 posted 14 years ago by karlhorky

Visual Basic getResultFromSQL(String) As Variant

This method runs a SQL query and returns the first result (the query is expected to return exactly one record and one field).

query
sql

0 488 posted 14 years ago by CaptainProton

Visual Basic isFoundInListbox(listbox, String) as Boolean

This method checks whether a ListBox contains a certain item (based on its text).

find

0 546 posted 14 years ago by CaptainProton

Visual Basic createQuery(String, String)

This method creates a query with a given name and given SQL. Note: Requires the deleteQuery(String) method.

query
sql

0 462 posted 14 years ago by CaptainProton

Visual Basic deleteQuery(String)

This method deletes a query with a given name. Note: Requires the queryExists(String) method.

query

0 463 posted 14 years ago by CaptainProton

Visual Basic queryExists(String) As Boolean

This method checks whether a query with the given name exists.

query

0 470 posted 14 years ago by CaptainProton

Visual Basic isDate(String) As Boolean

This method checks whether a given string is a valid date (current regional settings are used)

date

0 539 posted 14 years ago by CaptainProton

Visual Basic getNodeByKey(String, Object) As Node

This method returns a TreeView node based on its key.

find

0 482 posted 14 years ago by CaptainProton

Visual Basic Get all installed in system COM objects

PowerShell script. Get all installed in system COM objects.

windows

0 620 posted 14 years ago by AlexLocust

Visual Basic Remove Hyperlinks from Excel document

excel

0 494 posted 14 years ago by a1ias

Visual Basic Excel: Run Macro on Cell Change

The easy way to set this up is to go to the macro window by pressing alt+F11. Select the sheet from left panel. there will be two drop down. from the left drop down select worksheet and from right drop down list select the event 'change'.

excel

0 709 posted 14 years ago by derekholmes

Visual Basic Delete / Insert / Update tables in an Access-Database

VBScript!

0 846 posted 14 years ago by choasis

Visual Basic Create HTML Table in VB

Creates the table using the VB

table

0 930 posted 14 years ago by staley412

Visual Basic Find duplicate cells in excel column

excel

0 555 posted 14 years ago by a1ias

Visual Basic Attach to w3wp.exe keyboard shortcut macro for Visual Studio

Tools > Macro IDE > Add new item to MyMacros > Select Module, Name 'AttachToWebServer' > Copy/paste code. To set as a keyboard shortcut go to Tools > Options > Keyboard, and search for the name of the macro (AttachToWebServer) and then assign a ke...

0 716 posted 14 years ago by HologramX

Visual Basic Validation for a check box with a corresponding text field

validation

0 687 posted 14 years ago by heislekw

Visual Basic Validation for a combo box with a corresponding text field

validation

0 730 posted 14 years ago by heislekw

Visual Basic Look up all occurences and merge results (consolidate)

Say you've got data combined in such a way that there is a repeated row header, but all the data is in different rows. If you were to consolidate all the rows down to one, only taking valid values (discarding blanks), you'd have one header row with a...