scope

Below is the query I am working on. I am having an issue with my IIF Statement. Please tell me what I am doing wrong? I am trying to get the query to place a "DQIP" in the Deviations_Request.Information field if the Deviations_Request.Nonadoptcomment = "Taiwan is non GC country, DQIP is not in...

Hello, So I have a desire to change the color of the SCOPE of my comments in word via VBA. I understand that changing comment author's changes the RANGE of the comment, but it does not change the SCOPE color.... anyone know how to achieve this? Thanks!

Dear master, I want to ask about excel problem. How to add local scope of data to series value? This is my step how to create local data range Clik "formulas" tab >> clik data manager I fill name, fill refers to with =OFFSET(Template1!$B$3,Template!$M$5,0,10,1) Then i choose Sheet1 scope...

Hi, I have a sheet with 20 column and wanted to use the column headers as names, so I opted the Create name from selection option. It was a breeze to create so many names so quickly, but the problem is the scope of the names was set to Workbook. Is there any way to change the scope from...

Good evening, Mr Excel! I'm in the process of writing a dynamic programming piece of code as part of a university case study. The assignment itself is very open-ended and doesn't mention VBA so there's no need to worry that I'm simply scounting for answers. This would be the largest piece of...

Hi. I want to write a Sub. I want to Call the Sub from a UserForm Module (CommandButton_Cilck Event). I want to Call the Sub from a Worksheet Module (Selection_Change Event). What Type of Module must the Sub be in? What Type of Sub should it be? (Presumably Public) Currently, my Sub is a...

I have "variable scope problems". I have read the help, and I think I understand it, and I have my code organized so that I should have no scope problems.. But I do. Mostly, my problem seems to occur when I have a Function or Subroutine procedure which calls another Function or Subroutine...

Hi together! Having searched the forums I go crazy now with the following unsolved situation: I declare a public variable in a *standard module* to be used throughout the project. I can use that variable in that module. --- Option Explicit Public psWorkbookName As String...