Home > Need A > Need A Little Help With A Macro

Need A Little Help With A Macro

permalinkembedsavereportgive goldreply[–]b_b_atman[S] 0 points1 point2 points 1 month ago(3 children)I actually haven't even thought of doing this, thank you sir. This site is completely free -- paid for by advertisers and donations. Do I need to run that script every time I restart my computer in order for it to work? can you take a look and see where I am going wrong.

Can someone help me out? Is autohotkey capable of this? Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Again, I'm totally new at this.

Enjoy I guess!Code: [Select all][Download] (Untitled.ahk)GeSHi © Codebox Plus

{Esc}:: Pause, Toggle ; Pauses the script

^+{Enter}::

By continuing your browsing after being presented with the cookie information you consent to such use. Honestly I have never heard of the other one you mentioned. I believe this lets you see the what the function is doing. If so, is there a way to automate that so it works all the time?

Rollin Rollin_Again, Apr 13, 2012 #3 BFarmac Thread Starter Joined: Apr 13, 2012 Messages: 3 I have cut down the workbook to display the input data screen and two of Is it a difficult script? Ask here!Because the default UI is for squares.Issues with our site? Thank you so much!

Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Code: Sub TransferData() vSolution = Sheets("Input").Range("D7").Value Select Case vSolution Case "TBAH(0.1N)" Sheets("TBAH 0.1N").Range("D5").Value = Sheets("Input").Range("D7").Value Case "HCL04(0.1N)" Sheets("HCL04 0.1N").Range("D5").Value = Sheets("Input").Range("D7").Value End Select End Sub Regards, Rollin Rollin_Again, Apr 16, What I am trying to do is have the data go to the correct tab based on the Solutions space (D7). Top laserbunny Posts: 3 Joined: 12 Jan 2017, 05:46 Re: Need a little help with a super simple macro (I think?) Quote Accept this answer 12 Jan 2017, 06:58 I moved

I would like to run the macro with a (ctrl)(shift)(enter) hotkey and I would like to be able to stop it at any point with the (esc) key. This is the one that works but only send to the first sheet. Please redirect questions related to malware removal to /r/Antivirus or /r/techsupport. Super simple!

I am not opposeed to sending all the data to one page but I would still need help getting the information onto the other tabs. Use a modifier condition. I have a macro on the original document that moves the data when you click subit but it only sends it to the first tab. This won't work unless the data validation values in cell D7 matches the sheet name exactly which is doesn't.

  • Click here to join today!
  • Attached Files: Sample Log.xlsx File size: 115.5 KB Views: 42 BFarmac, Apr 16, 2012 #4 Rollin_Again Joined: Sep 4, 2003 Messages: 4,887 Your button click event or macro should have a
  • Or sign in with one of these services Sign in with Facebook Sign in with Microsoft Sign Up This Topic All Content This Topic This Forum Advanced Search Browse Forums Downloads
  • Sign in to follow this Followers 2 Go To Topic Listing AutoIt General Help and Support All Activity Home AutoIt v3 AutoIt Help and Support AutoIt General Help and Support Morse
  • Twilight's Hammer / Agamaggan et al.
  • Thank you so much!
  • we have some campaigns in the last days....
  • Is there an output screen on the bottom like Visual Studio when running a breakpoint? (This is more of a general question on analysis of MS Macros) permalinkembedsaveparentreportgive goldreply[–]El_Dorado_Native 1 point2 points3
  • Anyway no one wrote anything so here's something I made up.

permalinkembedsaveparentreportgive goldreplyaboutblogaboutsource codeadvertisejobshelpsite rulesFAQwikireddiquettetransparencycontact usapps & toolsReddit for iPhoneReddit for Androidmobile websitebuttons<3reddit goldredditgiftsUse of this site constitutes acceptance of our User Agreement and Privacy Policy (updated). © 2017 reddit inc. I need to run (Down)(PageDown)(Enter) in a loop like 700 times but with the ability to stop it at any point. but I suggest you read this announcement which clarifies what you can and cannot discuss on the forum with regards to key press detection. All rights reserved.

if A is entered I need all the information to go to the sheet marked A, if B is entered then I need all the information to go to sheet B. Rollin Rollin_Again, Apr 17, 2012 #7 BFarmac Thread Starter Joined: Apr 13, 2012 Messages: 3 I have tried to fit the code you supplied into my sheet and it didnt Well, either u name the sheet exactly as the part code or u go the long way of select case.

Join our site today to ask your question.

Please excuse my spelling I am dyslexic. Right now I only need it for a super simple macro. Sign In Sign In Remember me Not recommended on shared computers Sign in anonymously Sign In Forgot your password? Yup.

http://www.reconstructer.org/code.html permalinkembedsavereportgive goldreply[–]b_b_atman[S] 1 point2 points3 points 1 month ago(1 child)OfficeMalScanner? Blood and Gore Crude Humor Mild Language Suggestive Themes Use of Alcohol Violence Online Interactions Not Rated by the ESRB Forums Log In Shop Support Account Settings Games World of Warcraft® Diablo® Top Noob098124 Re: Need a little help with a super simple macro (I think?) Quote Accept this answer 12 Jan 2017, 06:22 How long of a pause in between? Tech Support Guy is completely free -- paid for by advertisers and donations.

Log In Return to Forum quote blizzardlogo netEaselogo Thanks for visiting the Blizzard Forums (2.14.0) · Patch Notes Support Feedback Americas - English (US) Region Americas Europe Asia China Language English Exxec 100 Undead Rogue 3010 91 posts Exxec Ignored 18 Dec 2014 (Edited) Copy URL View Post Yes it is. This is my first post here and any help will be appreciated.I'm quite new to any kind of scripting and I've been trying to make a script that types anything I From the countless testing on the dummy, I think it's when those 2 overlap that messed it up.

Support Europe - English (EU) Region Americas Europe Asia China Language English (US) Español (AL) Português (AL) Deutsch English (EU) Español (EU) Français Italiano Polski Português (AL) Русский 한국어 繁體中文 简体中文 Twilight's Hammer / Agamaggan et al. Is this possible with autohotkey? I'm still relatively new to all of this as well.

Shattered Halls / Sunstrider et al. Thread locked.M23  Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections Garf13LD, Apr 17, 2012 #6 Rollin_Again Joined: Sep 4, 2003 Messages: 4,887 Garf13LD said: ↑ Dim txt As String txt = Range("D7") Sheets(txt).Range("D5") = Sheets("Input").Range("D5") Do have error handling in case Jump to content AutoIt General Help and Support Existing user?

Anyone see anything like this before or any tips on how to proceed? Bring them here.GameplayDiscuss your class with people who share your pain.The place to talk PvE progression.Gank, twink, or pwn n00bs—just no flaming.Craft your way to success with Wowhead's help.TransmogrificationCombing the continents Not possible.http://www.wowpedia.org/Macro_conditionalsThat is every condition available to secure actions, such as spell casting. I would like to use the hotkey (ctrl)(shift)(enter) to run it and I would like to use the hotkey (esc) to stop it at any point.