DevZum

VBA Function to Return Worksheet Name from Code Name

Jordan Kendall — Tue, 17 May 2022 19:49:21 +0000

I tried to find simple function to return the worksheet name from a Code Name. As I was searching, many said I could not do it. If you know me, I don’t like it when someone says I can’t do something especially in Excel. Many searches consistently led me in the wrong direction. Thankfully through […]

The post VBA Function to Return Worksheet Name from Code Name appeared first on DevZum.

VBA Function to Browse & Select from Directory

Jordan Kendall — Mon, 18 Apr 2022 19:58:57 +0000

I have been building many applications using VBA to help users in automating processes. Somethings simply can’t be automated due to variability of some attribute. In my case determining the directory to use required input from the user. So I devised a simple function that will ask the user where the files are saved in […]

The post VBA Function to Browse & Select from Directory appeared first on DevZum.

VBA Function to Autosize Comment Box with Fixed Width

Jordan Kendall — Fri, 15 Apr 2022 00:13:52 +0000

I searched and searched and searched for VBA code that would allow me to autosize comment boxes, but retain a fixed width. This is very challenging and I will explain a little, but skip the short story and see the full code at the end of the post. The reason I needed this code was […]

The post VBA Function to Autosize Comment Box with Fixed Width appeared first on DevZum.

VBA Function to Create New Excel Worksheet

Jordan Kendall — Wed, 23 Mar 2022 20:12:05 +0000

I was working on several VBA macros to automate several processes and I found myself repeating certain VBA code within each sub. I decided that it would best to turn this into a public function that I can reuse over and over again. The code may not work for everyone, but where it is most […]

The post VBA Function to Create New Excel Worksheet appeared first on DevZum.

Excel VBA Storing Dynamic Arrays from Data Table

Jordan Kendall — Wed, 16 Mar 2022 22:26:04 +0000

While doing a Google search for “Excel VBA store data in array” I came across a post Excel VBA – Storing Data in Arrays & Dynamic Arrays by Chester Tugwell at BluePecanTraining.com that gave me what I wanted. I won’t go into as much detail as Chester, but after reviewing the VBA code, I was […]

The post Excel VBA Storing Dynamic Arrays from Data Table appeared first on DevZum.

The Importance of Stickers for Your Business Explained

Ian Wright — Tue, 16 Jan 2018 08:17:21 +0000

Did you know that not everyone is impressed by digital marketing? According to recent surveys, the most effective marketing campaign is a combination of digital and print because of the personal touch print brings to the table. The study found that customers tend to spend 25% more on your products/services if you are using a […]

The post The Importance of Stickers for Your Business Explained appeared first on DevZum.

Guide to Prevent CMS Based Website from Hacker

Elise Mayer — Thu, 11 Jan 2018 09:17:10 +0000

If you own a website, then there is a chance that your website can be attacked by hackers. It is easy to develop a professional looking blog and even easier to hack CMS websites. You might be tension-free because there is nothing to steal from your platform. However, most hackers tend to use your server for […]

The post Guide to Prevent CMS Based Website from Hacker appeared first on DevZum.

URL Character Codes Cheat Sheet

Jordan Kendall — Tue, 02 Jan 2018 21:29:24 +0000

URLs frequently use conflicting characters such as question marks “?”, ampersands “&”, hash “#” (i.e. pound or number sign), brackets “{}”, slashes “/\” and others. You may have noticed the escaped hexadecimal ASCII representations of these symbols in a URL. For example, have you seen a %20 in a URL? It stands for a space. […]

The post URL Character Codes Cheat Sheet appeared first on DevZum.

8 Reasons Why Having an Excellent Web Design is Not Enough!

Sunny Chawla — Tue, 14 Nov 2017 21:10:13 +0000

“A website is nothing until it has good web design.” This was one of the oldest sayings in the web design world. But nowadays, things are changing faster, especially with the pervasive use of free WordPress templates. We can see that today website design is only a single aspect out of many that make a […]

The post 8 Reasons Why Having an Excellent Web Design is Not Enough! appeared first on DevZum.

How To Create A Font Yourself

Irina Vi — Sun, 29 Oct 2017 07:32:08 +0000

How To Create Your Own Font Why create your own font? Not only is creating your own font beneficial for your brand and marketing, but it also cuts the cost of having to hire someone to create it for you. It will save you time, money, and effort when you are able to do this […]

The post How To Create A Font Yourself appeared first on DevZum.