Excel VBA

K

Kakane

New member
Joined
Jun 18, 2026
Messages
0
Reaction score
0
Hi,
Bought ‘Excel VBA: macro programming’ [Richard Shepherd] a while ago and have yet to really get into it - seems ever so dry!
Q: Anyone else taught themselves VBA purely from self-help books? Seems so tedious. Please share experiences and/or advice on ebooks that may make the process to mastery easier to cope with?
How did you get through the tedium? I don’t consider myself a programmer, not even close, closest I’ve come is XHTML on a few webpages.
Comments appreciated folks,
K
 
youtube is your friend and google is your best friend when it comes to self-help.
 
I taught myself VB…
The best is to have a goal, or a problem you want to solve… then google google google until you figure out how to code it. 9/10 someone has tried to do something almost exactly the same as you… thats when you check your book to see how you should tweak the code to fit your needs. Then after a while, you just start picking up how it works.
But I agree with ws… Google is your friend.
 
^ second what everyone else said
Also, macro recording then viewing the code is a huge help also
 
CF_AHHHHHHHHH Wrote:
——————————————————-
> I taught myself VB…
>
> The best is to have a goal, or a problem you want
> to solve… then google google google until you
> figure out how to code it. 9/10 someone has tried
> to do something almost exactly the same as you…
> thats when you check your book to see how you
> should tweak the code to fit your needs. Then
> after a while, you just start picking up how it
> works.
>
> But I agree with ws… Google is your friend.
+1
 
If I concatenate characters to create a string in a cell “=1+1”, how can I execute that statement in Excel (no VBA) to make the cell show 2?
 
Cheers for the responses,
Have yet to try Youtube, going to give it a whirl.
Many thanks,
K
 
Its easy to do one cell at a time. Copy paste value the cell that says “=1+1”. Then simply double click the cell (as if you were altering the formul) and hit return. The cell will then say “2”
It’s a little more complicated to do many (say 10,000) cells, but still pretty easy. Lets say you “=1+1” in cells b1:b1000. Enter this formula in cell c1: =”x”&b1. Copy this formula all the way down to b1000. Note: I arbitrarily picked “x”; any character will suffice. Then copy paste special cells c1:c1000. Highlite the values in column c and hit find/replace. Enter X for replace what. Leave the replace with entry blank. At this point, all of the cells will say “2”
 
Cells.Replace What:=”“”“, Replacement:=”“, LookAt:=xlPart
 
You must log in or register to reply here.
Back
Top