A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly by David Godinger[_2_]
I’m using UserInterfaceOnly, so that I can run macros and still keep my sheet protected. I tried to use ActiveCell to calculate only certain ranges, without...
July 27th 16 04:07 AM
by edelkochen Go to last post
5 410
VBA - How to "execute" a dynamic variable assignment by [email protected]
Cell A1: "MyVar" Cell A2: "Purple" Cell A3: "String" I want to run code that does the following Public MyVar as String MyVar = "Purple"
July 20th 16 05:29 PM
by GS[_6_] Go to last post
7 488
"Continue?" Message Box by Paul Doucette
I have code that runs when a command button is triggered, that does several things, including saving the file. After that command button is triggered, and...
July 18th 16 12:05 AM
by Paul Doucette Go to last post
4 311
Number of records for last 7 days by R D S
Hello, You guys have been very helpful to me in the past. I have a spreadsheet with a column of dates, I would like a textbox on a form display the number...
July 17th 16 09:04 PM
by R D S Go to last post
3 313
Need Macro help to stop repeating some info by ksquirt
I am trying to tweak a macro by adding new rows into the tabs and then add them to the macros for compilation in an email. The issue I have is that the...
July 14th 16 08:48 PM
by ksquirt Go to last post
2 439
Convert Numeric Values in Column to Text via VBA by [email protected]
Does anyone have some VBA code that will convert all numeric values to text value in a certain column, in a certain worksheet? Eg convert 630 to '630 The...
3 391
Password Cracker for Excel Worksheets/ Workbooks by [email protected]
This has been floating around for a while now, but I gave it a serious reworking. Option Explicit Public Sub AllInternalPasswords() On Error Resume Next ' '...
(Multi-page thread 1 2)
July 13th 16 11:32 AM
by Raj[_12_] Go to last post
15 2,685
Click on Webpage Box by [email protected][_2_]
I have been trying to click on the box labeled "Select Weight & Count" on the following web...
0 337
data filter via VBA by Paul Doucette
I have a command button that runs code in order to assign a random number and save a workbook. I would like to add a step to this code so that it takes the...
July 11th 16 01:34 AM
by Paul Doucette Go to last post
2 305
Print, Save as PDF, Email PDF code by Paul Doucette
I am looking to assign vba code to a command button which will do the following: 1) Print worksheet “Quote” and worksheet “Sheet1” to my default...
July 10th 16 03:15 PM
by Paul Doucette Go to last post
7 380
Find and Replace Q by [email protected]
I took the code below from SpreedsheetGuru, but want to tweak it for my specific needs and I am a little lost Code below Finds & Replaces from a Table values...
2 319
Angry
Programing to save who and when someone update the file by [email protected]
I'm trying to programing the file to save in the column "R" and "S" the timing and user who updated the file, but this only works for updating in the first...
July 8th 16 06:49 PM
by GS[_6_] Go to last post
4 305
Multiple selections simultaneously from a data validated dropdown list by Phrank
Hi, I've got my spreadsheet set where users are able to select multiple values from a data validated dropdown list one at a time. All values selected show up...
July 8th 16 04:16 PM
by GS[_6_] Go to last post
4 358
Copying/cloning an object by Walter Briscoe
I do a lot of scraping information into Excel 2003 from the Internet via Internet Explorer (IE). I would like to do overlapped IO. Grab the first piece of...
July 5th 16 05:53 PM
by GS[_6_] Go to last post
3 390
Error in VB Editor Coding by Tim Childs[_10_]
Hi I have used the code below to close the extra VB windows that end up being open when using the VBA editor. Sub CloseVBEWindows() Dim W As...
(Multi-page thread 1 2)
July 4th 16 02:20 PM
by GS[_6_] Go to last post
19 619
Comments do not appear by [email protected]
My application consists of a UserForm menu and several report sheet-tabs. The problem is when the selected report opens, and the user hovers their mouse over...
June 30th 16 06:28 PM
by GS[_6_] Go to last post
1 297
Active x control by Fawn Lagimodiere[_2_]
Hi. I have a combo box with active x control, however users are able to delete. Users are able to delete field from the combo box but I would like to know...
June 28th 16 05:43 PM
by GS[_6_] Go to last post
1 359
reverse of CHR function by c1802362[_2_]
Good morning all, Returning a character using the CHR function is simple: MsgBox Chr(65) returns 'A' However, is there a reverse CHR function that...
2 342
Writing formulae from array to range by Walter Briscoe
I started to compose this as a problem. I now have a solution, I would value an explanation. I have a second problem at the end. I have a sub which is worth...
June 24th 16 03:31 AM
by GS[_6_] Go to last post
2 317
VBA to send Outlook email - stuck in Outbox by Phrank
Hi. At work, employees have an individual report in a folder that they are supposed to do each day. When they are done, there is a signoff sheet in their...
June 23rd 16 04:42 AM
by Phrank Go to last post
9 644
Post New Thread


Display Options
Showing threads 141 to 160 of 174032
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.