Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-22-2016, 06:24 AM
cloudforgiven cloudforgiven is offline Button does not generate proper colors? Windows XP Button does not generate proper colors? Office 2013
Novice
Button does not generate proper colors?
 
Join Date: Nov 2016
Posts: 13
cloudforgiven is on a distinguished road
Default

Awesome it works, I am sorry for giving you more work but I also have a button that generates rows that is having the same issue of generating the rows but not the proper cell colors, can you take a look at it? here is the code:

Code:
Dim varUserInput As Variant
 
 varUserInput = InputBox("Enter The Last Row Number In The Table:", _
  "What Row?")
  
 If varUserInput = "" Then Exit Sub
 
    Dim RowNum
    
    RowNum = varUserInput
    Rows(RowNum & ":" & RowNum).Insert shift:=xlDown
    Rows(RowNum - 1 & ":" & RowNum - 1).Copy Range("A" & RowNum)
    Range(RowNum & ":" & RowNum).ClearContents


there are rows but no color?

Last edited by cloudforgiven; 12-22-2016 at 09:59 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
proper snoforlife Excel Programming 0 01-26-2016 02:16 PM
Button does not generate proper colors? Hyperlinks Not Linking to Proper Sections of Doc MoiraB Word 2 08-26-2015 07:13 PM
Proper Text Format sufian,naeem Excel 1 05-05-2014 05:59 AM
Button does not generate proper colors? Unable to change font colors from theme colors choy Word 3 08-01-2012 09:12 PM
Button does not generate proper colors? Proper Excel Table of Contents (ToC) judicial85 Excel 1 10-23-2011 01:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft