Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 48
Search took 0.02 seconds.
Search: Posts Made By: Zakalwe
Forum: Excel VBA May 1st, 2018, 03:14 PM
Replies: 2
Views: 1,289
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 you'll...
Forum: Excel VBA April 30th, 2018, 06:06 PM
Replies: 9
Views: 710
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 6th, 2018, 12:49 AM
Replies: 2
Views: 801
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, 05:34 PM
Replies: 8
Views: 703
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, 05:30 PM
Replies: 8
Views: 703
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, 05:27 PM
Replies: 8
Views: 703
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, 05:24 PM
Replies: 8
Views: 703
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, 04:25 PM
Replies: 8
Views: 703
Posted By Zakalwe
Appreciated bro, I enjoy helping. Now, I assume...

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, 07:56 PM
Replies: 8
Views: 703
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 then...
Forum: Excel VBA October 18th, 2017, 07:14 AM
Replies: 5
Views: 697
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, 07:25 PM
Replies: 5
Views: 697
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 the...
Forum: Excel VBA October 11th, 2017, 03:51 PM
Replies: 5
Views: 697
Posted By Zakalwe
Sub testall() For each myCell in...

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, 05:58 PM
Replies: 11
Views: 1,294
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 ' None...
Forum: Excel VBA October 10th, 2017, 05:52 PM
Replies: 11
Views: 1,294
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, 05:49 PM
Replies: 11
Views: 1,294
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 ' None...
Forum: Excel VBA October 10th, 2017, 05:47 PM
Replies: 11
Views: 1,294
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 ' None...
Forum: Excel VBA October 10th, 2017, 05:46 PM
Replies: 11
Views: 1,294
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 ' None...
Forum: Excel VBA October 10th, 2017, 05:04 PM
Replies: 11
Views: 1,294
Posted By Zakalwe
Been posting but it is somehow not...

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 WB =...
Forum: Excel VBA October 10th, 2017, 01:13 PM
Replies: 11
Views: 1,294
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, 05:38 AM
Replies: 9
Views: 3,148
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, 08:54 PM
Replies: 2
Views: 1,624
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, 02:08 PM
Replies: 10
Views: 1,233
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, 01:48 PM
Replies: 10
Views: 1,233
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, 12:49 PM
Replies: 10
Views: 1,233
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 suspect...
Forum: Access VBA March 13th, 2017, 12:18 PM
Replies: 10
Views: 1,233
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 08:55 AM.


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