Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 48
Search took 0.01 seconds.
Search: Posts Made By: Zakalwe
Forum: Excel VBA May 1st, 2018, 02:14 PM
Replies: 2
Views: 1,700
Posted By Zakalwe
It can be done without writing code.

Open VBA Editor, put it in design mode.
Choose to view properties of each toggle.
Point the LinkedCell of the toggle to the cell you want the toggle to update to.
For cells on different sheets...
Forum: Excel VBA April 30th, 2018, 05:06 PM
Replies: 9
Views: 1,075
Posted By Zakalwe
Work around

Tomurtis is correct.
However, you could use a script that copies and pastes values and number formatting in place.
Then call His function to do the formatting.
In turn, tie this function to an...
Forum: Excel VBA April 5th, 2018, 11:49 PM
Replies: 2
Views: 1,413
Posted By Zakalwe
Merged Source or Destination cells

That smells of Merged source or destination cells.

Double check that, if not then seperate the copy and the paste operations.
Wed have to see a snapshot of the source and destination to help
Forum: Excel VBA October 25th, 2017, 04:34 PM
Replies: 8
Views: 906
Posted By Zakalwe
These were scenarios where I needed to extra a...

These were scenarios where I needed to extra a specific pattern & composition of digits and text was of arbitrary length & composition.
Had to run it on about 200k records and do a inner comparison...
Forum: Excel VBA October 25th, 2017, 04:30 PM
Replies: 8
Views: 906
Posted By Zakalwe
Sub MasterClass() Dim myWbName As String,...

Sub MasterClass()

Dim myWbName As String, myWsName As String, myRngName As String, myRegExtInput As String, myFindWhat As String, myReplaceWith As String

Dim myUpdateCol As Integer,...
Forum: Excel VBA October 25th, 2017, 04:27 PM
Replies: 8
Views: 906
Posted By Zakalwe
Function StripNonDigits(myInput As String) As...

Function StripNonDigits(myInput As String) As String

Dim myRegExp As RegExp

Dim myMatches As Variant

Dim myTemp As String, myReplacement As String

Dim myCount As Integer
Forum: Excel VBA October 25th, 2017, 04:24 PM
Replies: 8
Views: 906
Posted By Zakalwe
Function FindDigits(myRegExp As RegExp,...

Function FindDigits(myRegExp As RegExp, mySentence As String, myMin As Long, myMax As Long)

Dim myMatches As Variant

Dim myTemp() As String, myStrip As String

Dim myCount As Integer
Forum: Excel VBA October 25th, 2017, 03:25 PM
Replies: 8
Views: 906
Posted By Zakalwe
Appreciated bro, I enjoy helping. Now, I...

Appreciated bro, I enjoy helping.

Now, I assume you'll always read the 2 strings before the search string.
Answer is regular expressions.
Refer to the site: analystcave.com

I don't have any...
Forum: Excel VBA October 23rd, 2017, 06:56 PM
Replies: 8
Views: 906
Posted By Zakalwe
Cool Lol. For some reason I end up answering all your...

Lol. For some reason I end up answering all your questions.
Will give proper answer tomorrow mornings. Almost 1am in South Africa.

Question: is the composition the same: date, time, 2 strings...
Forum: Excel VBA October 18th, 2017, 06:14 AM
Replies: 5
Views: 971
Posted By Zakalwe
Happy you are sorted. About variables in the...

Happy you are sorted.

About variables in the module, it is a good practice to have everything under one main Sub, kind of like a wrapper, then call your worker functions within this wrapper.
Your...
Forum: Excel VBA October 16th, 2017, 06:25 PM
Replies: 5
Views: 971
Posted By Zakalwe
Remember the only actual variable is the current...

Remember the only actual variable is the current cell you are testing.

The function takes the presented cell and does its classification job, release resources after.

Maybe you should send me...
Forum: Excel VBA October 11th, 2017, 02:51 PM
Replies: 5
Views: 971
Posted By Zakalwe
Sub testall() For each myCell in myRow.columns...

Sub testall()
For each myCell in myRow.columns
If myCell(1,1)= 5 And myCell(1,5) = 15
Validation1 myRow
my cell.interiorIndex.color = 16
Else If myCell(1,1)= 5 And myCell(1,4) = 3
ValidationX...
Forum: Excel VBA October 10th, 2017, 04:58 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Macro

Sub Macro1()
Dim WB As Workbook
Dim WS As Worksheet
Dim myCell As Integer
Dim myWhite As Integer, myGrey As Integer

Set WB = Application.ThisWorkbook
Set WS = WB.ActiveSheet
myWhite = -4142...
Forum: Excel VBA October 10th, 2017, 04:52 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Been posting but it looks like the page is slow...

Been posting but it looks like the page is slow to update.
Don't be surprised if you see several posts of the code.
Forum: Excel VBA October 10th, 2017, 04:49 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Sub Macro1() Dim WB As Workbook Dim WS As...

Sub Macro1()
Dim WB As Workbook
Dim WS As Worksheet
Dim myCell As Integer
Dim myWhite As Integer, myGrey As Integer

Set WB = Application.ThisWorkbook
Set WS = WB.ActiveSheet
myWhite = -4142...
Forum: Excel VBA October 10th, 2017, 04:47 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Sub Macro1() Dim WB As Workbook Dim WS As...

Sub Macro1()
Dim WB As Workbook
Dim WS As Worksheet
Dim myCell As Integer
Dim myWhite As Integer, myGrey As Integer

Set WB = Application.ThisWorkbook
Set WS = WB.ActiveSheet
myWhite = -4142...
Forum: Excel VBA October 10th, 2017, 04:46 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Sub Macro1() Dim WB As Workbook Dim WS As...

Sub Macro1()
Dim WB As Workbook
Dim WS As Worksheet
Dim myCell As Integer
Dim myWhite As Integer, myGrey As Integer

Set WB = Application.ThisWorkbook
Set WS = WB.ActiveSheet
myWhite = -4142...
Forum: Excel VBA October 10th, 2017, 04:04 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
Been posting but it is somehow not updating. ...

Been posting but it is somehow not updating.
Heres the code below.

Sub Macro1()
Dim WB As Workbook
Dim WS As Worksheet
Dim myCell As Integer
Dim myWhite As Integer, myGrey As Integer

Set...
Forum: Excel VBA October 10th, 2017, 12:13 PM
Replies: 11
Views: 6,558
Posted By Zakalwe
White/default color has a specific color code, ...

White/default color has a specific color code, so you want to check if the color code is different than white code then do any action.
To find out what colour is white, record a macro, change to...
Forum: Excel VBA October 8th, 2017, 04:38 AM
Replies: 9
Views: 3,761
Posted By Zakalwe
Alternatively Use a collection or a File

Hi,

I believe a collection with these codes as keys and the numbers as values will work best.

Alternatively have the collection reading from a file of keys and value pairs.
Forum: Beginning PHP March 13th, 2017, 07:54 PM
Replies: 2
Views: 2,470
Posted By Zakalwe
Hi. Start at codecademy.com or w3schools.com

Hi.

Start at codecademy.com or w3schools.com
Forum: Access VBA March 13th, 2017, 01:08 PM
Replies: 10
Views: 1,681
Posted By Zakalwe
I'm Not Sure if you are getting my text, browser...

I'm Not Sure if you are getting my text, browser is not updating, but I am getting updates via mailbox:

I'm going to use code from this site to cut the amount of work, very useful site:...
Forum: Access VBA March 13th, 2017, 12:48 PM
Replies: 10
Views: 1,681
Posted By Zakalwe
Wink Im going to use code from this site to cut the...

Im going to use code from this site to cut the amount of work, very useful site: http://codekabinett.com/rdumps.php?Lang=2&targetDoc=send-serial-email-access-vba-outlook

I am combining their code...
Forum: Access VBA March 13th, 2017, 11:49 AM
Replies: 10
Views: 1,681
Posted By Zakalwe
Better. Do this, Debug.print...

Better.
Do this, Debug.print rs!qryCustomersExtended.EmailAddress
Check what it gives you.
Put it just a line above the line that gives you the error
Set a breakpoint on the error line. I...
Forum: Access VBA March 13th, 2017, 11:18 AM
Replies: 10
Views: 1,681
Posted By Zakalwe
I'm Not Sure if you are getting my text, browser...

I'm Not Sure if you are getting my text, browser is not updating, but I am getting updates via mailbox:

I'm going to use code from this site to cut the amount of work, very useful site:...
Showing results 1 to 25 of 48

 


All times are GMT -4. The time now is 03:30 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.