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 5 of 5
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 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 June 8th, 2016, 11:11 AM
Replies: 3
Views: 591
Posted By Zakalwe
Hi, your comments do not match your code. ...

Hi, your comments do not match your code.
Using the description you wrote : use a case or multiple ElseIf statements.
If Target.Address = Me.Range("F30").Address Then
Do ABC...
ElseIf If...
Forum: Excel VBA May 27th, 2016, 02:10 PM
Replies: 4
Views: 963
Posted By Zakalwe
Hi Loki, Sorry I never received your reply...

Hi Loki,

Sorry I never received your reply in my mailbox.

Can you email me a sample?
zweniryu@gmail.co.za

zweniryu at gmail dot co dot za
Forum: Excel VBA April 13th, 2016, 04:41 PM
Replies: 4
Views: 963
Posted By Zakalwe
Hi, it is possible. VBA has a formula...

Hi, it is possible.
VBA has a formula property where you make entries that will appear as a formula.
Now the question is are the sheets in one document and if the sheets have the default names...
Showing results 1 to 5 of 5

 


All times are GMT -4. The time now is 04:17 AM.


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