Skip to primary content
Skip to secondary content

My Excel Database

My VBA codes history

My Excel Database

Main menu

  • Home
  • Posts’ list
  • Other
    • VB.net
    • VB
    • WordPress
    • Others
  • Contact
  • About me
  • Log In

Category Archives: VB

On this page, I’m presenting code that I’ve used to write the application in VB. Following examples were placed on my old page years ago. I’ve not checked the code and I’ve not used it for long time – I do not guarantee that the code examples from this page have any value. I’ve excluded this category from main page, to show only Excel and VBA categories there that I’m interesting the most.

Text value dividing

Posted on 20 December 2017 by pawel
443

Something we have to divide some text value for two separated elements. VBA code contained to this post show how to do this. Of course shown code is quite simple – it has to be rebuilt for yours needs.

Continue reading →

Posted in VB | Tagged Array, divide text, InStr, Space, Split | 443 Replies

Item removing from MySQL via Visual Basic

Posted on 20 December 2017 by pawel
598

In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?

Continue reading →

Posted in VB | Tagged Connection to MySQL, delete from, item removing | 598 Replies

Language

English Polski

About website

Website showing coding examples found in internet and  used by me. Was created in order to find working code in new projects. This is a source for my future applications to find needed code fast and easily.

Video presentation (PL)

https://www.youtube.com/watch?v=ysJDqAbEOSQ

Visual Basic .NET

  • UnobtrusiveValidationMode jquery w VS for Web

    I’ve wanted to add login control to my test website... Read more →

  • Connection string encryption in VB.Net

    After hours of tests I’ve succeeded in ConnectionString encryption in... Read more →

  • Filling and centering GridView in VB.NET

    GridView in VB.NET is the same control as DataGridView in... Read more →

  • ConnectionString for MySQL w VB.NET

    ConnectionString for MySQL w VB.NET For now I’ve only tested... Read more →

Visual Basic

  • Text value dividing

    Something we have to divide some text value for two... Read more →

    Something we have to divide some text value for two separated elements. VBA code contained to this post show how to do this. Of course shown code is quite simple – it has to be rebuilt for yours needs.

    (more…)

  • Item removing from MySQL via Visual Basic

    In the project I still making I’m using MySQL database... Read more →

    In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?

    (more…)

Recent Posts

  • VBA not recognizing polish letters
  • Checking if another Worksheet is opened and its opening or closing
  • Folder creation
  • Removing duplicates in collection
  • Creating HTM file via Excel VBA

Recent Comments

  • War in Ukraine on Creating HTM file via Excel VBA
  • War in Ukraine on Get SAP format date
  • War in Ukraine on Connection to SAP HANA via Excel VBA
  • War in Ukraine on Connection string encryption in VB.Net
  • War in Ukraine on ConnectionString for MySQL w VB.NET

Categories

  • Excel
  • Others
  • Power Query
  • VB
  • VB.net
  • VBA
Proudly powered by WordPress